訳:The demand for new homes is weak.
Exactly. In English, "of" is used to show possession or to indicate a smaller group within a larger group.
The demand of people = people's demand. The students of a school = A school's students.