I'm skeptical because
1. a large part of the housing pressure in many urban places is artificially created by the past several decades of bad building/zoning policy.
2. the usual type of struggling rural community we think about is often more than an hour from a big city. I doubt even a self-driving car makes a 3-5 hour roundtrip commute appealing. And this doesn't address traffic at all, which is already often the bottleneck of how far out from a city it is feasible to commute from.
I'm generally excited about the prospect of self-driving cars but apprehensive of this idea that it will let us continue/increase our suburban sprawling for free.