Related: The origins of Doom's sound effects: https://www.youtube.com/watch?v=9bgFpss0YFE

Sound effect in question (104/107) is "FIRE, BALL - IMPACT AND LARGE FIRE BURST, RUMBLE" from The General Series 6000 Sound Effects Library

There were sound effect samplers that went around on CD back in those days. Presumably purchasing the CD came with a license to use the effects in your projects. There was also a wind noise sound that found its way into many different game and motion picture productions that I always instantly recognized.

The life of sound effects is a strange thing, with its own semi-commercial ecosystem. Read about The Wilheim Scream (https://en.wikipedia.org/wiki/Wilhelm_scream) for a glimpse into how they move from one production to another.

There are various sound effects libraries that offer premade effects clearable with simple terms. So it’s simply different teams taking the same sound off a library CD / website.