I think the future of pesticides and weed control in food production will be robots manually removing pests. No chemicals required.
The technology we have today isn't too far off from this... weeds are certainly easier than bugs, but both should be feasible.