Rent costs are complicated. A big part of the reason that SF housing is so expensive is that it is so desirable to live and work there. Companies want to be there because that is where the talent and capital is, and talent wants to be there because that is where companies and capital is, and capital wants to be there because that is where the companies and talent are. High cost is what keeps some companies/talent/capital away DESPITE the benefits of being in the area... but if we lower real property costs, MORE companies/talent/capital will want to be there and the cost saving won't persist. There is latent demand ready to fill up any extra housing you build.
There have also been studies that ask this same question, and they have found that opening up housing development in high rent areas just means developers build more luxury living places, and costs don't go down.
https://www.citylab.com/equity/2019/05/housing-supply-home-p...