Acceleration of multi-species ions in CO2 laser-produced plasmas: Experiments and theory