We could be in a space where it makes sense to dump tons of resources into rapidly progressing automation because it would enable people to finally stop doing tedious labor.
I dont think this is true.
Space mining is only for resources to use in space. The economics of transporting resources back to earth will never stack up.
I dont think any significant number of humans will spend any amount of time in space in any practical time scale.