He was a really interesting guy too.
He remained a devout believing Catholic throughout his life, while living a decidedly not Catholic lifestyle. He would like go to mass or confession, and then do lines with hookers (off hookers?) at night. While that is not being a "good Catholic" I don't think that's all that unusual of a struggle for Catholics. And the religion is pretty much designed around that central conflict (although few of us can live Farley's lifestyle).
With the rise of Protestant evangelicalism as the default image of Christianity, there's a lot of focus on hypocrisy, and exuding your faith from every pore all the time in every single thing you do and every word out of your mouth, and that there's a special perfect life you can lead if you just love Jesus enough.
Traditionally Catholic teaching recognizes our fallen nature and the struggle and it's kind of built into the whole thing. But the more modern approach by people since evangelicalism became dominant, is that if you struggle with certain sins or with understanding or accepting certain aspects of the faith, you shed the whole thing, lest you be labelled a hypocrite.
So it's interesting to me that Farley didn't shed his faith, he struggled with it. And as Catholics, we're supposed to struggle with it until we get it as right as we can, and nobody gets it all the way right. That aspect of him resonates with me a lot, even though his lifestyle is obviously an extreme example.