Sometimes they do. A friend's brother basically makes his living playing for churches he's not a member of. I don't get it, but there it is.
I was very briefly a music director at a church, that paid, but to be honest it didn't jive with me getting paid for services by a church I didn't go to. Generally though, I'm not certain that it does pay.