It sucks doesn't it? I liked him a ton too and it's kind of a kick in the nuts he turned out to be this way. But he is human, and was a pro athlete, which means we kind of build an image of what we think they are.
Sometimes we are right ( see Payton Manning, Barry Sanders etal.) And sometimes we are wrong like with Favre.