People move to where they can make a living. Globalization has largely killed farming as a viable livelihood (in most of the EU at least), it's simply not profitable enough unless you have a massive amount of land/cattle or have invested heavily in automation (usually both). Without that important sector, it's doubtful the trend will reverse unless cities become literally unlivable or there's some kind of miracle in transport technology.

For Finland it seems that it is not the farming automation that kills these places. It is the deindustrialisation. Places die as the jobs die. And jobs are killed by big factories being closed leading to all other services starving. Globalisation is the killer, but via factories not farms.

The trend will reverse once we have enough people in positions of power both able to recognise and willing to admit that remote work is, for at least 75% of office jobs, at least as good as onsite work. (Not "without tradeoffs", just "at least as good, overall".)

Sadly, this is going to have to be at least a generational change, as the current people in power are deeply entrenched in the mindset that "managing people" means "ensuring butts are in seats", and that they are neofeudal lords overseeing their techno-serfs, which they can only feel good about if they can go aggravate them in person.