Depends on how the wastewater would have been treated before.

Wastewater treatment does release CO2, however the sludge can be fermented to biogas. So in relative terms not that much. Also the sludge contains phosphate that could be recovered for fertilizing or chemical industry purposes.

It would probably be far more effective to build renewables with that money than to bury things for which a treatment process already exists.