People don't hate automation. They hate BAD automation.
From your description seems like: Waymo -> Good Automation, Call Center -> Bad Automation.
The day we will have a chatgpt level automated customer care experience, we will complain every time humans answer our requests, with their accents and attitudes!
Oh man, hope it's ok to poke a little fun. I think we just violently agreed with me praising automation from one company and deriding automation from another. So I'll update your "seems like": Riding with Waymo (IME) -> Good Automation, Lyft customer support when they "stole" $3 from me and didn't provide me with a way to fix it -> Bad Automation.
In the broad sense, people are in favor of automation. Most people aren't clamoring for the days before the stove, dishwasher, and car (all automated versions of past technologies).
That being said, I think a lot of people are against automation when it does something worse than the manual version. Think automated customer service over a human being.
I don't see people hating that their network packets are automatically routed through the internet
"Hi, how can I help y—"
"TALK TO A ROBOT"