This sound effect can be found on The Producer's Sound Effects Library, which was made by Joel Valentine.
https://soundeffects.fandom.com/wiki/File:PSEL,_FIREBALL_IN_3._DULL_HIT.ogg