I am definitely not an expert on the subject. But doing some basic web searches and I note how much more of the infrared spectra is absorbed by water vs the relatively narrow band that co2 absorbs. As a infrared emission blocking gas water vapor is several times more effective than co2. this is fine, we don't want earth to be a freezing ice cube. but add the excessive amounts of co2 and you start to get an alarming condition.
The atmosphere is currently ~422 ppm of CO2, and an average of ~5,000 ppm of H2O, with humid tropical areas having up to ~50,000 ppm of H2O.
Water vapour makes up ~half of the greenhouse effect. It's not a 'good' greenhouse gas, it's just that there's a lot of it in the parts of the world that get a lot of sun - the tropics.