UPS is already using Natural Gas/Diesel hybrid engines for runs between SoCal and Vegas.
So that use case has a strong argument for CNG.
Weight doesn't really matter for a personal automobile, and you can't (easily) make the tank big enough to argue that a large tank is cheaper than a large battery. It's true, but costs unrelated to tank size are still important, and the bigger issue is that the range sucks unless you give up the entire trunk (since you can't make a CNG tank flat (like Tesla) or T-shaped (like GM).