Residential vs. non-residential zoning always tries to tilt towards non-residential, because it has a better potential of return.
Although both pay property taxes and both require utility services like water, sewer, and waste collection, non-residential properties attract both in-town residents and outsiders from other jurisdictions, who then typically spend some money in your town. Meanwhile, residential attracts new residents, who may or may not take jobs in your town, could be spending money in other towns, but need high-cost social services like public schools and community programs in your town.
That explains why Edinburgh allowed the St james centre to exist right in the city centre instead of keeping the existing housing stock there: https://en.wikipedia.org/wiki/St._James_Centre. The whole thing has been pulled down and a mixed development should be take its place in the next few years (alreayd underway).
Although both pay property taxes and both require utility services like water, sewer, and waste collection, non-residential properties attract both in-town residents and outsiders from other jurisdictions, who then typically spend some money in your town. Meanwhile, residential attracts new residents, who may or may not take jobs in your town, could be spending money in other towns, but need high-cost social services like public schools and community programs in your town.