This sound effect can be found on 20th Century Fox Sound Effects Library, which was made by Sound Ideas.
https://soundeffects.fandom.com/wiki/File:Sound_Ideas,_SIREN,_AIR_RAID_-_GERMAN_AIR_RAID_SIREN.ogg