At least two (that I know of) of the churches that I have been a member of in the last twenty years has Deacons and Elders who were armed. No one knew “exactly” who was armed at anytime, but everybody knew they were there. In actuality, I think all of them were armed all the time, but only God and them know for sure.
I often carry a Ruger LCP (380) for daily wear. For church, I’ve settled on a Glock 27 - 9 rounds of 40 S&W - as my minimum. I consider churches to be high threat zones. Kind of like movie theaters used to be.