Same sex couples in the church

I had this conversation with my Ex and I think about it a lot. I went to his church with him a few times (I'm atheist and he's Christian) because I wanted to be supportive of him. I can't remember how we got on the topic but he told me that gay people can't be a leader in his church (I might be using the wrong terminology). I asked him why this was and he told me it's because the purpose of sex is to have children and gay couples can't have children. I asked if the same rule would apply to infertile couples and he said no. I asked what if the gay couple adopted a child and he said that wouldn't count. I pointed out that one couple that leads the church couldn't conceive naturally and adopted and they obviously were accepted into that position. I wanted to know what the difference was. He couldn't give me a logical non homophobic answer. I'd hoped I'd made him think a little more about it but on a later date he admitted to me that he believed a same sex couple would never be as real as we were as a couple. I have a few gay/lesbian friends and it really hurt me that he would think of them as less than. Glad I broke up with that prick