You answered your own question.

“Why doesn’t the state build housing?”

“Profit going back into the city budget.”

There’s your answer. No incentive for the state to fund housing if all the revenue is going to go to the municipalities.