It was a smaller (from 90s) v6 or even v8 gas car. The point is to manufacture a car, a tremendous amount of energy is used in everything, from breaking up rock, extracting the iron ore, smelting to make steel, to machining, to etc...
The CO2 emitted by the car during it use,( and you are correct, only ocassional few weekends use) is a rounding error.