We've done this before, and it turned out great.
In the industrial revolution, tractors and machine looms and steam engines did all the old 'menial' jobs. We just invented new jobs that pay better with all the extra wealth created by automation. The middle class grew and quality of life skyrocketed.
It was arguably the best thing to ever happen to the world.