at what point the projectile goes transonic (and starts to tumble)
Cause and effect. Going trans-sonic doesn't necessarily cause a projectile to tumble if it's spin rate, kinetic energy and aerodynamics are 'correct'. On the other hand, tumbling will make one go subsonic pretty quickly.