There still must be some input of energy. From what I understand, the Sabatier reaction is really only viable from an environmental perspective if it is powered by some other non-carbon energy, such as solar or wind.
But yes offsetting CO2 produced due to energy is a waste.