This is a Skywalker Sound sound effect. It may be considered as a stock sound effect, but it was probably created by Gary Rydstrom. Its earliest debut may be Ghostbusters II (1989). Links: https://soundeffects.fandom.com/wiki/SKYWALKER_EXPLOSION_10_/_SKYWALKER_FIRE_ROARING_SOUND#Audio_Samples