I know several people who decided to get smaller yards or were happy to move into apartment complexes without them.
We both are dealing with biased samples. A childhood friend who is very into the outdoors moved to a rural area and got 14 acres, everyone else moved to an apartment or a house with under an acre. This stuff shows up on migration patterns, and well there’s a reason the Rural Midwest USA is a small percentage of the US population.
So, I agree many people do want a large yard, but revealed preferences suggest it’s a minority opinion.