I think it is the common perception ( slow shutter, water reflections....) of how a fireworks shot should be that caused such disappointment.
The fireworks are way up and for sure u can take it unobstructed, try taking at high iso, fast shutter speed in this type of conditions.
Also if too many people blocking, u can use them as foreground which may reflect the mood nicely.
Hope this helps