SMS dit: Forecasts for low spin black hole spectroscopy in Horndeski gravity