Agricultural Pesticides between Productivity and Ecological Risk: A Critical Narrative Review of Benefits, Environmental Harms, Resistance Evolution and Sustainable Alternatives