nuclear bomb, no.  Seriously worse than gasoline, yes.  Mogas just isn't as volatile as LNG.  You don't get the big vapor cloud forming.  Typically mogas has a boiling range of 100F to 430 F.  You can get it to boil off, but over time rather than a rapid, BLEVEE situation. Otherwise we'd have pressurized mogas tanks in our cars.    Mogas tends to burn, LNG to go BANG.

Distillate -- no worries at all.  It vaporizes, but slowly.  Great for avoiding killing aquatic life, but little risk of an explosion.

I agree with you.  It's pretty hard to actually fuck up enough to cause the worst case scenario.  Unfortunatly, we humans seem to always find a way to do just that.  I wouldn't want to live 1000 yards from an LNG facility and wouldn't want to ask anyone else to do so either.  Whereever we put them, and we do need them, we need to maximize the distance to people.  Fear no, caution yes.

The Exxon Valdez also had many compartments.  All oil tankers do.  But like the Titanic, when a tanker hits a rock or another ship rams you at an angle, you tend to slide along it rupturing a number of tanks.  The product tankers I used to charter would hold 250 MB of liquid in usually 15-25 individual tanks.  Crude tankers not all that different in design.  You need a bunch of tanks for stability and to prevent the liquid from sloshing around in heavy seas.