The reason we zone this way is because people are unable to imagine their lives without being able to drive around. The very first thing people say in my town when an apartment tower goes up is "where am I going to park? Do they have a plan for moving the parking spots that this tower displaced? Traffic on tower St. is going to get so much worse!"
If the expectation is that everyone owns a car, upzoning is a huge problem -- it actually is, because everything that scares a car brain ("I can't park!" "It's going to be loud!" "This will increase traffic!") is actually true. Rather than limiting cars, of course, we choose to limit zoning. Which is actually quite a logical thing to do if everyone is to own a car.
If you get rid of cars you get rid of collectors, arterials, onramps and offramps, turn lanes, parking spots... Those are things that are fundamentally incompatible with a major, dense, vibrant city. You can easily fit 50,000 people, their workplaces, senior care homes, schools, and restaurants into the land area of a 4 way cloverleaf that is designed to service 50,000 round trip commutes by car.