I think the article's theory on why people plow is wrong: it is not to let the soil hold more water, but to get rid of weeds. I know someone who did no-till for a while, and he found that you have to spray with glyphosate to keep the weeds down. Eventually the weeds that had evolved to be glyphosate-resistent spread to his area, and he had to go back to regular plowing. He said that the no-till really improved the soil, though.
I think no till makes most/only sense for intensive market gardening. Where you're weeding by hand or in greenhouses and maybe applying a recurring layer of compost and maybe cover crops to prevent the soil from being bare.
Spraying a little glyphosate emits a lot less CO2 than plowing.
Weeding actually seems like a fantastic usecase for those humanoid robots like figure, unitree, atlas etc. it’s easy and accurate plant recognition is mostly a solved problem.
No-till requires to have different crop patterns, where you plant again right after harvesting to avoid weeds overgrowth.