The scary bit for LNG is a BLEVE (Boiling liquid expanding vapor explosion). Even non-flammable liquids undergoing a BLEVE can be incredibly destructive, for example:
https://www.youtube.com/watch?v=fgdfgxLApL4
So it's nothing to do with vapor cloud detonation, that's pretty much irrelevant compared to the destruction of the rapid phase transition from liquid to gas.