I would imagine this works best for large scale projects that are on nice flat land?

So plenty of room for humans to handle smaller/trickier projects. And of course to look after the machines that are doing the work.

Turning a blind eye to climate friendly tech for fear of losing (potential) future jobs doesn't seem wise, and it's irrelevant anyway in our capitalist society where someone else will just follow the money and step straight into your place.