We have been automating away jobs pretty frantically since the Industrial Revolution started ~250 years ago.

It has always resulted in no long term effect on unemployment and higher worker wages.

If you don't understand why that counterintuitive thing has consistently happened for centuries, you probably shouldn't speculate on the current automation wave.