I have been making software professionally for 25 years and in all that time i have never run into the problem that we have run out of things to do.
It's quite hard to predict what will happen, but in a few years, I bet the unemployment rate of tech workers will be really high, we can just look at how many jobs are currently already replaceable but the owner of it is just lagging in the implementation of automation, it's probably already the large majority of tech jobs.