This sound effect can be found on FirstCom - Production Elements.
https://soundeffects.fandom.com/wiki/File:FirstCom,_Siren_2.ogg