We already have CNG buses and garbage trucks here in San Diego and there have been no problems. People don’t even realize it.
I was involved in India when they started switching buses and taxi’s to CNG city by city. The impact there on pollution was dramatic going from smokey old diesels to CNG.
At some point, even CNG is going to be demonized - just wait.