New to ExPo and been mainly lurking, but finally a thread pops up I can contribute to.
I'm in the oil industry in Oklahoma and have previously owned 2 bi-fuel CNG/gasoline pickups. CNG is indeed catching on and I believe it will become a viable nationwide daily driver alternative to gasoline/diesel/ethanol in the future, but it's not quite there yet, especially for an expedition rig. There are a number of issues
1) Weight, which you've already considered. Those tanks are big and heavy, even if you get the Type 4 Composites. There are some interesting developments on the horizon with Chesapeake's partnership with 3M to use advanced composites in CNG tanks, but that isn't market ready yet.
2) Cost. You're looking at $10,000 plus to convert a gasoline powered rig to CNG without buying tanks. I had a new 24.5GGE Type 4 tank in one of my trucks and it cost over $4,000. For 120GGE, you're going to fork out $20,000+ just on tanks alone. If you get a medium-duty diesel powered rig, the only viable option (IMO) is to find a used CNG Cummins out of a schoolbus or something similar. Also, 120GGE of tank space will mean you'll probably only get 90-100GGE of usable fuel in the tanks due to the pressure differential required to move the gas through the regulator.
3) Availability, which can be managed with proper planning and routing.
4) Dependability. Not of the vehicle, but of the CNG stations themselves. This is something you don't really consider until you actually have a CNG-powered vehicle. At least half the stations I know of have broken down for extended periods at various times. Many stations only offer 3000psi fills (for the older schoolbuses and fleet vehicles from the past 2 decades) which will further diminish your range. Every single station I've been at has occasionally given me such slow fills that I end up leaving before even filling a 21GGE tank. Some stations have inadequate compressors or storage tanks that are too small. Some fleet CNG fill stations are open to the public, but only during daylight hours. I had to skip University of New Mexico's station the day after Christmas because they had it locked up in their fleet yard (which is open when the school isn't closed).
There is a reason dedicated CNG fleets are generally used only locally in conjunction with a privately-owned fill station. You can't depend on the infrastructure if you are running on Empty and it's the only CNG station in the state.
One day CNG will be a great option. It's a cleaner, American-sourced fuel that offers great cost savings and utilizes infrastructure that is already in place in most of the country. For now, I'd hold off.