Well the short aswer is nobody knows. The Brailsford comment has been spun way out of context, he merely stated IF Cav wanted to move away he'd understand and would not stand in his way - perfectly fair and sensible. My opinion is that Cav knew exactly what he was signing into and whilst the reality hit home in the early stages, the tour ended in an amazing high for him and he will still be there at least next year. But thats all it is, an opinion from an outsider.
There is no question that a sprinter's ambition will be compromised in a team with serious GC goals. BUT he still won 3 stages, could have contended two more if it weren't for crashes. He got 3 rather than 5 due to his own misfortune, not team compromise, and unless: a) Sagan's a cheat b) he is a flash in the pan or c) they change the points competition / sprint parcours dramatically - Cav won't be winning Green for some time I think. I'd also add that Sky only had 8 men for the majority of this tour, and comfortably won, so they may feel they can dedicate an extra man to Cav next year. They may also feel they can afford to help chase breakaways down more as their confidence grows. Sky wlll raise their ambitions and want multiple yellows as Brailsford has stated. He also said he wants this to be regarded as the greatest team ever. What better way to make this statement than to win on more than one front?
This is an amazing team and Cav will still want to be there next year I think