What others think

I have a son who is gay. We go to church in a very conservative church. If I support him and his partner I am worried how people will view it and how they will treat me. I’m worried that they might not be kind to him and he will leave the church. How do I lose the worry about what other people think, not let it bother me?