Fireworks are dark rides are about as different applications as you can get. What's great for one may be lousy for the other. Dark rides are difficult, you'll want a fast lens, like Bob said.
But fireworks can be taken fairly well with almost any lens, since ideally, you'll be using a medium aperture, around F8-F11, and most lenses do fairly well in that range.