Secondary scintillation yield of xenon with sub-percent levels of CO2 additive for rare-event detection