Didn't Mythbusters basically bust this, as hot water heaters having so many safeguards to prevent this and even if all the safeguards failed it won't explode so much as turn into a rocket?
Edit: Reading the article states the same, still I wouldn't call it exploding.