Normal fireworks designed to make a colourful display in the night sky don't really upset our pets. It's the ones designed to cause as much noise as possible that are the problem.
Why they don't ban fireworks that make a loud boom, I can't fathom. People have no consideration when they let them off, and cause disturbance to the small hours.
Sale of fireworks should also be limited to a few days before Nov 5th and New Year's, and not sold at other times. No need for a total ban, just control the noise output and opportunities to buy them.