The majority of the water a plant absorbs is lost to the air as transpiration. Different plants lose different percentages of water this way, so high water use doesn't necessarily mean more CO2 absorption.

https://en.wikipedia.org/wiki/Transpiration