> which requires constant, continuous resource extraction

Is there an upper bound on battery limits with regards to resource extraction?

It's probably fairly high, considering the existence of the sodium-sulfur battery. It's not economically competitive since it operates at high temperature, but it's based on very abundant materials.

Once you have enough to power the world and are able to recycle them, then you're done with extracting resources for them.