Yup as we saw last week a US DDG can take a direct torpedo hit and only break some glassware. Amazing machine.
What does it take to sink a ship?
http://www.military1.com/all/article/504-what-does-it-take-to-sink-a-ship
I would not want to be on a ship where the explosion is on the ship...
http://breakingdefense.com/2014/01/top-tester-tells-navy-to-test-carrier-destroyer-defenses-with-real-missiles-explosions/