I suspect you mean either CNG or LPG, not LNG.
LNG required constant refrigeration down to -260°F or it constantly will boil off requiring venting (or keeping the engine running).
but it may be too volitile for urban or suburban areas
LNG or CNG is just natural gas, methane. LNG tends to be more pure methane because of they cryogenic freezing to make it liquid.
LPG is propane used for the BBQ.
Yes, it needs insulated tanks that will keep it from getting warm before it's used. In a dual-fuel vehicle (like UPS's LNG trucks), you fill up with not more than the amount of LNG you expect to use in the next few hours, and then when it's done you use gasoline/diesel. With commercial vehicles, you have a good idea of how much fuel you will use that day, and can fill up accordingly.
But the increased overall supply of NG should also drop the price of LPG, as the source of that is also NG, should it not? And in point of fact, might not LPG function as a "bridge fuel" to CNG?? Conversion of a gasoline powered vehicle is much easier than for LPG than for CNG. Given the ubiquity of the use of LPG in motor homes (not as engine fuel, but for heating, refrigeration, and generator fuel), there are probably already many more "fueling stations" in existence than for CNG.
Heck, even the little "convenience store/gas station" near my home has an LPG "fueling station", and this is WAY "out in the sticks".