Zoning doesn't change that a lot of people
do want single family detached homes. Those zoning rules weren't handed down by some solo dictator far away they were decided by the people living in those areas.
I do agree there should be more options in the housing market, but in the end there is some percentage of the market which will prefer to not live in flats and rowhouses.