This sound effect can be found on Sound Effects 1, which was made by the William B Tanner Company.
https://soundeffects.fandom.com/wiki/File:William_B_Tanner_Company,_Artillery_Explosions.ogg