These two images are typical rural sprawl compared with Central Manhattan, on the exact same scale. Now I'm not an expert on these matters, but something tells me pollution, traffic and logistical problems would be much, much worse is everyone had their own plot of land.
This story doesn't address the cost of all the transportation infrastructure to build out ot these towns in the first place. The cost of vertical farming greens/pigs near cities vs the cost of rural farming communities will reach a tipping point. At least at the level of lifestyle most Americans would be willing to accept with sprawling Walmarts and cheap fast food, some towns might become unviable to live in. Ghost towns can happen in any generation.
The whole rewilding thing might happen if urban areas start attracting even farming talent to the cities.
IDK comrade, the carbon cost of transport of food is not really that big in comparison other factors. The idea of increasing the capital intensity of farming by an order of magnitude (without, mind you, a commensurate decrease in labour requirements) by farming vertically doesn't really sound like a realistic goal in our lifetime we have other things to deal with that are more important.