Cristiano Ronaldo’s struggle to deal with his reduced status is putting his Manchester United legacy at risk