This sound effect can be found on Disney Ideas Sound Effects Library, which was made by Sound Ideas.
https://soundeffects.fandom.com/wiki/File:Sound_Ideas,_GUN,_TANK_-_MILITARY_TANK_CANNON_SINGLE_SHOT.ogg