This sound effect can be found on Universe of Sounds, which was made by OMI.
SNES:
https://soundeffects.fandom.com/wiki/File:OMI,_Thunderstorm_01.wav