It's interesting that you name those examples, because Lee Sedol, the all-time great Go player, retired shortly after losing to Alpha Go, saying:
"Even if I become the number one, there is an entity that cannot be defeated... losing to AI, in a sense, meant my entire world was collapsing... I could no longer enjoy the game. So I retired." [1, 2]
So for some, yes. It is of course also true that many people derive self-worth and fulfillment from contributing positively to the world, and AI automating the productive work in which they specialize can undermine that.
[1] https://en.yna.co.kr/view/AEN20191127004800315
[2] https://www.nytimes.com/2024/07/10/world/asia/lee-saedol-go-...