We attend a church that preaches anything outside of heterosexual monogamy is “in contempt against the will of God,” and they’re both in agreement.
That’s traditional Christian belief. Many gay people come from religious families. It makes your choice to tell them more difficult, but if they are generally understanding and sympathetic people, it may not be bad as you imagine. What brand of church?