Not everywhere, you are looking at only suburbs vs cities.
The amount of people that want truly rural environments is infinitesimal.
Everyone wants a huge house with lots of land far from neighbors.
But then they want the state of the art hospital to be close. They want to be able yo reach the closest airport in max 1 hour. They want their kids to play with other kids, ideally without being chauffeured around endlessly, etc, etc.
What I've discovered is that humanity has mastered the ancestral art of "having the cake and eating it, too", also called delusion and/or hypocrisy :-)
True rural farming is still bad for nature because the land is cleared of biodiversity to make way for farm land. It is arguably worse than cities because a lot more land per person is cleared.