None of my current dogs are scared of fireworks, however that could change at any point, and we work hard to try to ensure it doesn't. If anyone has dogs who are NOT scared, please work on pairing fireworks with reward to keep them that way.
The issue isn't really the noise... its the unpredictable nature of fireworks and the fact that their use is, currently, something impossible to police.
We can limit sales of them. But once in the hands of the public there is next to no way to stop people mis-using them, or take action once they have.
So yes I am in support of a ban on sales to/use by the general public.
I think you should need to obtain a licence to use them, that licence would be granted only if you have a suitable venue to let them off at, insurance for that, and you'd have to advertise the event to reasonably let those within a particular radius know about it well in advance.
That way those who do want to use them in the main, could still do so - licence holders details would be kept so misuse would be easier to police and take action over, we'd have fewer accidents as venues would need to be appropriate...
And those scared of fireworks for whatever reason, can take steps to avoid it - with previous dogs, we'd drive somewhere quiet for the evening, have a walk, picnic in the car etc... not fun, but achievable for one or two nights out of the year.
Wildlife are still fucked of course, plus plenty of older people who can't go and hide for a night, it isn't a perfect solution but it does reduce the harm somewhat, and the major harm is the unpredictable nature and the misuse by people who should never have been permitted to use fireworks in the first place.