Hydrogen has been used as a rocket fuel. Would you consider it a cleaner fuel than CNG? Why or why not?

Hydrogen is much cleaner fuel than CNG because while the burning of hydrogen only water is produced, which is totally harmless but on the other hand, burning of CNG produces carbon dioxide gas and water. The carbon dioxide can produce greenhouse effect in the atmosphere in the long run.