You may consider this an excuse of the kind "but that's not nuclear power's fault" and you'd be right-ish, but I simply don't care who exactly is at fault for whole regions to become uninhabitable in case of disaster.
That is connected to nuclear power in my risk assessment, even if you can make a rational argument that it shouldn't be. And I'm very risk-averse when the magnitude of consequences is that big.
Same with Fukushima: yes, everything was safe. Unconnected to the reactor per se they made huge planning errors, underestimating a tsunami. Again, I don't care.
It may be a bias or even a fallacy that Kahnemann has already described, but it's a useful and correct fallacy, I would argue.