This is why our standard of living is much better now than it was 150 years ago. Even though we have autoamted pretty much all of the jobs since then, except teacher and lawyer (there is another term in economics for what happens here: https://en.wikipedia.org/wiki/Baumol_effect)
Personally I think it's fine, even as my own profession undergoes the same transition. We now have new jobs in running the waymo fleet in various capacities - the cars still need to be serviced, cleaned, supported, scheduled, etc - and the highly compensated jobs designing what are essentially real-world robots that can safely coexist with humans on the road. This is how technology has always worked and it's always made us better off on the whole.
Also, the new product is just better. When a human is not in the car, it's ok for to leave them waiting for a few minutes to pick me up if it's not a busy street, and I don't have to deal with the risk of an unsafe or unsavory person hosting me in their personal vehicle. I can control the music and the AC, and tap a button to have the car pull over. I can and do still take Lyfts and Ubers when I need to - it's cheaper for anything involving the highway, still, and better when I need to get somewhere in a hurry.