This sound effect can be found on the Hanna-Barbera Sound Effects Library, which was made by Sound Ideas.
https://soundeffects.fandom.com/wiki/File:Sound_Ideas,_Explosion_-_Shell_Scream_%26_Explode_In_Distance,.ogg