It's a strawman to compare detached suburban housing to the densest housing options on the planet. If you do that, it's only fair to compare it against cabins without utilities, off road and miles away from the nearest grocery. Very, very few of the "majority of Americans" want to live in that.
So, be honest and just compare suburban sprawl against, well, normal development where people can build town houses, duplexes, small apartment buildings, and of course small stores and restaurants. THAT is the density that the majority of people are talking about. Not high rises in ultra dense urban cores. I think more Americans than you think would like to be walking distance from a decent grocery store, bar, and breakfast place. I enjoy it!