No, it usually has 70% to 90% less CO2 emissions compared to fossil based fuel, because there are CO2 emitters in the supply chain: Transportation, heating, food for workers, etc. This is the same reason renewable energy has a small CO2 footprint as well. However for e-fuels you need about 6 times as much energy to go the same distance with an electric vehicle. So you have to build 6 as many renewables (only then do e-fuels make sense) compared to electric cars.