Probably not.
Certainly not in the U.S. We don’t have the population density in our urban areas (save always the NYC metro and a handful others) to accommodate people organizing their life around not needing a car. And we’re almost certainly not going to any time in the foreseeable future - that’s been the trend for decades, and if anything the pandemic moved population even further away from dense urban areas. And the long-term shift of our population away from the geographically constrained northeast/midwest and the far more land-rich Sun Belt is just going to continue.
Not likely anywhere else, either. European cities have much more developed mass transit systems and a legacy of massive amount of urban stock (housing and commercial) that was developed before the automobile…and cars are immensely popular there as well. Not like the U.S., but European automobile ownership has been climbing for decades as well:
Motorization rate in Europe (EU-27) | Statista.
Cars are just too good at moving people around for us to give them up. They’re just better at providing mobility than mass transit in most circumstances. Sure, in super-dense central business districts in major metros (again, NYC and a few others) spatial limitations mean you have to have mass transit. But otherwise - and especially if EV’s eliminate a lot of emissions and autonomy eliminates a lot of accidents - most mass transit modes are outdated.