The thing that makes me more optimistic about this specific question is chess. Chess has been, from a human perspective, fully solved by AI. But it has never been more popular. Why? I find it both hard to explain and kind of intuitive. Even though we can't beat computers anymore, we can still learn from them, but remain human, and so human play remains its own unique thing, but infused with insights from the super human computer players. And on net, human chess is now just better.
I think science and math could be the same, which is really exciting! That is, maybe humans would be learning from what the super-human computers are doing, but using that to do different, more human, things.