Two things can be true.
Seeing your best friend suffer a devastating injury is hard and it's understandable for a young man to be emotional. There's no shame in crying and nothing wrong with what we saw from CJ.
and
Someone susceptible to those emotions, with complete inability to get past them, is unlikely to be the fierce competitor and leader needed to be an elite QB who can lead a franchise to a championship.
He's not Tom Brady and that's fine. If I'm a Texans fan I'm way more concerned with his play and significant regression this year. He looks lost and I'm not sure he's even a top 15 QB currently. Probably shouldn't have spent all offseason parading around talking himself up on every podcast known to man.
The media got to his head but he's young. Hopefully this year is a humbling experience for him.