I am a musician/cantor in a small Roman Catholic community. I wear my kilts regularly. There are a few situations when I don't wear the Kilt, but that's my own self imposed choice based on not wanting to distract people from the service. I get pretty much the same reaction from people at church that I do anywhere else, some are confused and some are enthused.
Jamie