Even if all the soil for growing food goes to crap, we can just engineer food crops that can grow in that soil.
It’s not about soil going to crap its about the climate surrounding those areas changing. Moon and Mars experiments are about indoor climate controlled greenhouses which sure can be done anywhere but not at the scale needed for our current civilizations or to replace the agriculture infrastructure at scale we have now.