So many of these ideas are some other vision in disguise.
Cars are bad, you see, and therefore, let's pick some irrelevant problem (parking lots), and conflate it with housing issues.
First, most places have zero housing issues. Mostly, certain tiny areas(with large populations) of California do, but the rest of North America has no shortage of land to build on.
And unlike California, most of the world doesn't seem to have issues with zoning for new builds.
In fact, in most of NA housing is quite affordable, with the exception of a current bubble, which exists due to COVID issues, a once in a century event.
This has only been going on for a year or so, and is already starting to cool.
Californians: a note. Your issues are not nation wide.
Others: stop trying to solve other pet peeves, by conflating issues. I assure you, you just end up sounding uninformed.
No. The problem is "space is being used inefficiently." The reason to get rid of enormous surface parking lots is to build more efficiently, not to kill cars.
I think you'll find if you increase housing supply and density you're likely to end up with more natural spaces, not less.