People are doing this for fun basically, or if the car is otherwise non-functional. There's almost no possible way the energy involved in doing this in a working car outweighs the CO2 savings you'll get.
Especially an infrequently driven classic car. Unless you're running no cats and drive it well over a thousand miles a year you'd never reach a net neutral emissions.