Diabatic ramping spectroscopy of many-body excited states for trapped-ion quantum simulators