It's almost as if a balance could be achieved, both by reducing the number of cars and increasing the number of trains/busses.
In case of Finland summer cottages are one such case. They're extremely common, and located in areas that usually have no public transport. Lots of people have also older relatives who live in middle of nothing.
The need for car ownership would plummet if we had self-driving cars that can autonomously drive back to the city, and to pick you up from the countryside.
House prices are almost far higher in big dense cities, so people are clearly willing to pay a premium to live there.
People either want or need to live in big cities.