Not inherently no, but when what you've committed yourself to is the Rights & Dignity of Sapient Beings (not to mention the establishment & perpetuation of same) it's hard to imagine someone losing Faith in that without taking a nosedive into a very black hole indeed.
I don't know? I imagine, at least to a degree, that this is what Picard is going to be about. He's lost his faith in an organization that he has served his whole life.
...without cheering for nasty characters in fiction.
I think it allows people in real life to vent without picking up a gun and either putting it in their mouth or going on a killing spree.