You shouldn't be so hard on yourself, not everyone loves fireworks. Not everyone loves them to the point that in a lot of countries it's illegal to have your own fireworks and people only get to see professional events.It is hard to respect my reactions to things though when I do not see examples of other people feeling they way I do. Hundreds of thousands of very happy people come to the fireworks show, so it must be a wonderful thing and something is wrong with me.
In Australia only one state allows personal fireworks and that's supposed to only be for 5 hours on one night of the year but there's a lot of idiots out there too. For some even the big boom of fireworks isn't enough and in the rural areas around Darwin you hear people detonating pipe bombs. The fire brigade hates them, the wildlife carers and animal shelters hate them, and quite a few residents hate them too.
It's something very exciting for children the first few times they see them, and as a young man it was also very exciting to be able to set off my own fireworks as well, but that thrill doesn't last long for most of us. The novelty wears off pretty quickly, I haven't gone to see a fireworks show for more than 30 years.