I personally don't think the price will ever drop low enough for it to make sense to most people to drop cars entirely. The US is notorious for being unwalkable, save for a few select areas.
Working remotely helps a lot since there's no need to drive every day, but it's only a fraction of overall people who have this privilege.
Still, I'm looking forward to seeing Waymo at my town. It would make a good DD and backup in case my car needs repairs, etc.