I don't look at reddit so can't comment on that. However, I usually see Twitter, youtube comments and the few bungie forums i seen in the early stages tell me that 98% people although they hate they miss him, its completely the right call.
I hope those few do leave if thats the case. They must see through it that itd the best thing to happen as they must be emotionally connecting to the story.
As much as I say its the best thing for the game and story, Cayde-6 will be the best character they've had since the start. He has been the best part of most missions over both games for me. His sarcasm just worked.