(Space is NOT the final frontier; sorry Trekkies. The real barrier to space is the ability to traverse non-trivial expanses of space in human time, and that will only be solved by Science.)
And when it comes to AI in research, we have just been handed a relativistic starship to explore the boundaries of our knowledge, instead of the paddle boats we've been using all this time. I would choose to adapt and try to harness this new power rather than mourn the loss of paddling.
In fact, I suspect most of the "jobs" left eventually would be around extracting those secrets out of the universe and making them work for humanity. Which is probably a much better use of human intellect than pretty much anything we do today.
That may be the future we want to end up in, but we'll only get there eventually. Unfortunately, in today's world we neither know the secrets of the universe nor can we survive without jobs. So until society reorients itself towards that future, we are going to have a lot of upheaval.