I think we have already faced the worst possible failure mode with Tsernobyl. That is the fuel going up in the air with burning material. Can't get any worse than that, and compared to produced electricity it resulted in not that many deaths.