I don't think homosexuals should be a church leader just like I wouldn't want a Christian who might occasionally get drunk as a leader, I;m not sure however that one sin is worse than the other as long as they both want to be free,and I don't think the church needs to turn their backs on them.
I do not however agree with all the world council of churches BS.
RH,
I'm not sure occasionally getting drunk make a person a drunkard. I consider that label for those who are continuously drunk, the to point it negatively affect the lives of themselves and others. Kink of like your example of a woman wearing jeans, or Hope wearing the Tux in China.
However, an practicing alcoholic may not be the best church leader.