If you build a bunch of houses then you have a larger customer base and tax base and have the money to provide more services.
The real issue is that if you get a bunch of new lower income residents who consume more in services than they pay in taxes then it raises costs on the existing residents who have to make up the difference. But if that's the concern then better to use flat-rate service fees so that new lower income residents are at least paying for what they consume than to do something even more regressive with zoning by effectively excluding them from the community entirely.