We are escaping this zero-sum game with innovation. We are finding replacements for expensive materials or figure out how to use less of them. Innovation and knowledge are compounding: a bit more knowledge today means a bit more knowledge a year from now, and then a bit more knowledge a year later etc..
No, we're replacing finite oil and gas with other finite resources. Sun and wind require hardware to be converted into usable energy, that requires finite materials.
Sun and wind also require massive energy storage solutions to replace the ease of storing energy in the form of oil. Again that energy storage requires finite materials to make, maintain, and replace as they degrade.