I am a supporter of equal rights and gay marriage. When I see comparisons made to other civil rights issues (i.e. "Would we accept this guy as CEO if he thought interracial marriage was wrong?" or "Would we accept this guy as CEO if he thought women deserved less pay?") it seems like a no brainer to me that, no, a person who held those views would never be tolerated as a CEO. And gay marriage, gay rights are an important issue and should be held in the same regard. Using that logic, one could conclude he is not CEO material. Not to mention that as a representative of the company they are getting some unpleasant press over this, nor does he seem to have the confidence of his employees that a leader should have.
On the other hand, it seems distasteful to me that we say to people, "We don't like your views. You need to go away now." ... Shouldn't diversity of thought, diversity of social and cultural and religious views be considered a good thing in an organization? Shouldn't we be trying to build teams of people with whom we aren't always going to agree on things with?