I think a big part of it is that they’re dangerous. It’s fun to experience just a tinge of fear from how big they sound, or even just from being near the little street versions. It’s a (relatively) safe way for us to experience something that would otherwise be terror inducing explosives.
They’re safe relative to other explosives like bombs.