Testing ISM models using ALMA-observed CO excitation of dusty star-forming galaxies