"This is different than, say an alcholic being put in charge of a liquor store."
One difference also is the alcoholic is not asking that the Church bless his drinking habit with a rite. Let's say that he demands that he bring is booze into church and have a blessing and the congregation glories with him in his addiction/habit.
Gays have been very successful in the protestant world gaining "same-sex blessings" where the couples get a cermony known as gay marriage.
A short internet search on "open and affirming" congregations yields me 100 or more churches in my area that accept the gay life-style and AFFIRM it. Open and affirming is the next step -- heads up guys -- let's not fall for this one.
As far as I know gays have had very limited success gaining approval for same sex relations, let alone marriage in protestant churches.
There are actually only a handful of fringe denominations that accept such things.
The vast majority of protestants reject the idea of gay marriage.