This sound effect can be found on RH 46/47, which was made by Robert Hall Productions.
https://soundeffects.fandom.com/wiki/File:Robert_Hall,_Rocket_Into_Space_%26_Shock_Waves.ogg