The problem is that pursuits you mentioned are 'winner take all' examples. Who knows the name of the 29th best chess player in the world? Probably not very many. And that's still a very formidable bar to cross for most humans on earth.
So then, what does a laid off business analyst who built and edited spreadsheets most of their life are to do now? Pick up athletics in hopes of making it at the seniors' olympiad? Shake their ass on TikTok in hopes of becoming a 55 year old "influencer"?
i mean, i think a lot of people probably know the 29th best chess player in the world. they may not be world-renowned but i bet the experience of that person is that they get a lot of respect for being super good at chess. people still play chess at all levels to try to better themselves - i think most people who play chess don't do it because they think they'll eventually get to #1 in the world (same with basketball, or any sport).
a business analyst who edited spreadsheets already wasn't particularly high status - i'm not convinced their life would be worse if the job was removed from their lives and they could do whatever they wanted instead.
What? We’re talking about a post-scarcity future and you think someone will be depressed because they don’t get to edit spreadsheets anymore? Poor guy only has infinite opportunity to pursue their limits (or not!) in the area of their choosing…
Do I play hockey with the end-all-be-all of becoming the next Gretzky? Or do I play because I enjoy it and want to push the limits of my mind and meat-suit?
I've always wondered who the fans of minor league sports are, but I assume there's enough of them beyond the athletes' families and the major league scouts trying to farm the best players for their own teams. There's a niche for anything.
We celebrate the highest achievers most, but that doesn't mean that the rest of us don't feel satisfaction in similar pursuits. Many people gain satisfaction from improving their skill at chess or sports or other crafts. I play ultimate (frisbee) twice a week, and I can assure you it's not because someone might eventually pay me to do so. I do keep trying to improve though. I'm glad that my work schedule leaves me the time and energy to do that.