For one thing, in the USA, our building codes and standard methods for making apartments makes it very difficult and space inefficient to make apartments with enough bedrooms for families. Affording a SFH is only so desirable because there aren’t apartments big enough for families to grow into, and while moving to a rural area might allow for enough living space, now the family has to figure out how to have a job that supports them.
Worth noting as well that it’s not just space. The construction and maintenance standards for US apartments are pure garbage. Every corner that can be cut, is. The kitchens are terrible, the insulation, thermal and acoustic, is subpar (if it’s even present - it wasn’t in any apartment that I lived in since 2000). They are frequently built purely with slum-lords rent-seeking from those who can’t afford a voice in mind, and little to no consideration for the inhabitants beyond appearing to meet building codes.
In order for Americans to buy into dense residential, it needs to be built in a way that it hasn’t for at least 50 years.