Extremely simplified: residents use democracy (in the form of zoning regulations) to vote out people they don't like. This effectively forbids the construction of affordable housing.

The demand is there, but the supply is not allowed to meet it.