My dad was similar to the lady in this cartoon when I was little. It was only when I connected the dots and asked him, "Since Jehovah is magic and he hates magic...why does he hate himself?" that something clicked in his brain and he became less insane regarding his beliefs in general. He'll still yell at Catholics on the TV, but that's just because he's got a particular...dislike for the Church, due in no small part to his (Catholic) father being a complete, utter lecherous old fucknugget whom no one will miss once he goes six feet under.
Honestly, it depends a LOT on the family and congregation in general. Mine had a similar distaste for witchcraft and such, but it was more geared toward active witchcraft, like making an altar and trying to cast a curse on someone you hate. They didn't see much of an issue with weed or booze, from what I recall, only that they really hammered home moderation with that and everything else. Not all of 'em are insane and/or stupid. Just like the Catholics, Baptists, Methodists, and other Christian sects, they've got their share of nutballs.