The nuclear industry has a couple of worst case scenarios which are extremely frightening. From the sabotage of a nuclear facility to large scale accidents like in Japan. I know not many industries which have that.
I remember years ago, the air here in Germany was very dirty. Then there were tighter regulations and improved technology. Now the air is much better, still not good enough in some areas - but the difference is huge.
When you have an exposure of radiation here, then you can't clean it up. The particles are everywhere. Tighter regulations will not bring improvements. The damage is done. Possibly for decades.
People here accept neither coal plants nor nuclear technology. They demand that most of the investment in future energy technology goes into renewables. This will not bring improvement in a day, but after a few decades a multitude of actions will make dirty and/or energy production phased out.
This scenario is planned here for Germany in 2050. Fourty years from now. Under the impression of the Japanese problems with their nuclear power plants, people are willing to accelerate that.
This means that for years there will be investments in new technologies, there will be implementations of those that not everybody will like, but Germany is a country with engineering tradition and this is a challenge people like.
So I don't really know that this makes a tiny probability of a nuclear accident all that acceptable. That said, I'm not against nuclear energy, but the probability of accidents needs to be next to nothing. Build enough reactors near fault lines and the probability of one of them receiving an 8.9 earthquake would surely approach certainty.
Sure, in the worst case a nuclear reactor can kill thousands and make large areas no longer habitable, but this event has only a tiny probability. On the other hand conventional fossil fuel plants don't have such a dramatic worst case but they produce a constant stream of greenhouse gases and other toxic fumes. How many people died because of smog? How much land will become unusable due to global warming?
It's the expected harm we should be worried about, not the worst case scenarios.