I would liken this to airplanes. They are similarly difficult to engineer and maintain, they can also go very very badly in mere minutes if operated incorrectly, they also have very costly recovery procedures if they crash somewhere populated.
For both systems there have been catastrophic accidents that were national tragedies, from which we learned a lot. "The rules of aviation are written in blood," and that is also true for reactors. Past failures like the one you linked don't mean that reactors are unsafe; if anything, because we had that failure to learn from, reactors are now much safer. If we had a volatile technology like nuclear reactors and none of them had ever had any accidents, then I would be very hesitant to have one in my home town since it could very well be the first to ever blow up.
I think the reason they have seen a lot of success where nuclear reactors haven't is simply up to the fact that they are both cheaper to build and that the public can very directly see where the benefit to them comes from, whereas nuclear power is abstract and indistinguishable from coal to the average person.