I fear you are correct. 20 years ago a Haliburton frack crew had 60 guys working on it. They've streamlined and automated so much, they now only have about 20 guys working a crew. So now there are 40 guys who would have had a fantastically good paying job who are doing something else instead.
Jobs will never completely go away, but the good jobs will get fewer and fewer. Then what will we do? We can't all drive for Door Dash.
Door Dash will be automated too.
Well crap! There goes my new career.
I am working on my lapdancing skills as we speak.
Bwahaha! I'll tip you a $2 bill, but you can hold the lapdance.
Go work for SpaceX. There are hundreds of Mechazillas and thousands of Starships to be constructed over the next two decades and then heaps of heavy construction on Mars itself over the next centuries.
I like the way you're thinking!
And asteroid mining. Will be mostly automated but still need people to fix and direct the machines.