Optical enhancement of superconductivity via targeted destruction of charge density waves