It's intuitive to think of wasted compute capacity as correlating with a waste of material resources. Is this really the case though?

Waste is subjective or, at best, hard to define. It's the classic "get rid of all the humans and nothing would be wasted" aphorism.