The Orthodox do not accept gay rabbis. For other streams of Judaism it has almost become a requirement that the rabbi be gay. In fact you are at a disadvantage if you are not gay when it comes getting these jobs. I believe most of the members of these congregations are not at all comfortable with having gay rabbis at the helm but the boards are filled with activists trying to look avant garde. Looking 'cool' will not save liberal Judaism. Only the Orthodox are likely to survive.
Palestinians, IDF clash in Jalazone after funeral of teen killed by IDF on Friday (Haaretz)
from the article: Gay man chosen to lead U.S. Reconstructionist rabbis