Visible spectroscopy of the new ESO large programme on trans-Neptunian objects and Centaurs: final results