I assume current technology requires significant fossil fuels to be used to manufacture and transport the type of batteries that can replace the heavy lifting that fossil fuels do.

We have electric cars and whatnot, but they're still far more expensive than fossil fuel cars with less bang for the buck in terms of power and portability. I doubt we will see cost effective construction vehicles, ships, planes, etc. powered via batteries anytime soon, at least not on a timescale that makes a material difference.

https://www.iea.org/world/energy-mix

22.9% natural gas + 30% oil + 27.6% coal = 80.5% of the world's energy coming from fossil fuels today.

Fossil fuels are still a very powerful, cost effective, and versatile battery compared to electric batteries.