so, what do you do, then, if your six year old kid comes to you and tells you they want to go to church?
i'd have a talk with them about it.
i would not be willing to bring a child to church on request, but i would allow them to go with a different adult, a friend's family or even by themselves, depending on context. i don't believe in helicopter parenting; i'd have little concern about letting a five or six year old kid go to church on their own, so long as the church doesn't throw them out for being disruptive.
i would make my concerns known to the child, and explain why i don't want to go, myself. but, i wouldn't stop them from going.
i may engage them in debate when they get back, though.