People's personal relationships are often messy, and don't perfectly align with political worldviews.
I am not vindicating anything he did, but storybook heroes like Picard rarely have the kind of glaring faults that one can find with a steady celeb searchlight and hindsight on real humans.