Fireworks offer visceral enjoyment because it's explosions overhead. Drones don't offer this but they do have a "wow" factor for their novelty. Now that the novelty is wearing off there's little left to actually enjoy.
The absence of explosions makes drone shows much more enjoyable for some people. Explosions are also the reason fireworks are banned and/or regulated in lots of places most of the time.