This sound effect can be found on Universal Studios Sound Effects Library, which was made by Sound Ideas.
https://soundeffects.fandom.com/wiki/File:Sound_Ideas,_DEPTH_CHARGE_-_RELEASE_DEPTH_CHARGE_INTO_WATER_03.ogg