Asymmetry in Raman Resonant Excitation Profiles of Single-Wall Carbon Nanotubes: The Role of Kohn Anomaly, Optical Transition Order, and State-Mixing