What is shown by this is that, when you build more housing in desirable areas, people will always move in to fill it. The value of which being that more people can now experience such desirable areas. In fact, the price decreases aren't coming from the actual housing supply increase directly, but that prices fall when there is a bigger competitive pool of those seeking housing and those supplying it even with 1:1 increases on both sides.
So what's the solution?
The truth is there isn't one, in our current political environment we will neither see a command economy that seriously solves housing issues (or even something like what singapore does). We won't see national multifamily by right zoning/building codes that enable economies of scale for high density construction. We won't see every suburb in America allow density increases to the level that automotive travel becomes a serious hassle. Additionally, we won't see major financing efforts come about for new housing production at the scale of a trillion dollars a year (which is the level of investment needed from a debt financing perspective).
Within the broader market, the cost of financing and construction are just too high right now for housing prices to fall on the production side of the equation. It is not possible to build 1000 sqft apartments in existing dense parts of the US that cost $100k on the production side (what it would cost to build a similar sized average single family home) in any of these major cities, and that's before land acquisition costs.
The truth is, that the most viable way for creating affordable housing in this country right now would be to build an entirely new city made up of moderately sized row homes that would have the ability to sprawl as such for 60 miles in any direction from its center.