The real issue is the fossil fuel sourcing of the hydrocarbons that go into the cars, trucks, jets, rockets and ships, as well as into industrial production of ammonia, steel, and various materials. Ultimately all the hydrocarbon feedstocks will have to come from capture and reduction of atmospheric CO2 to methane, RP1 jet fuel, etc.
It's really inevitable - even if climate wasn't a concern, eventually fossil fuel reserves will be depleted and even before then, the costs for new tech will be lower than for old tech (witness the end of the steam engine).
However, for most transportation needs, electric vehicles will be the preferable option, with exceptions for international jet travel, long-distance bulk shipping, and rockets for space launches (due to the much higher energy density of chemical fuels relative to battery storage).