The idea of racial equality has been around a lot longer and is more generally accepted than gay marriage rights (which only recently have begun to gain wider acceptance) so I imagine more people would be on the “he should resign” side in such a case.
When I first heard about this issue I didn’t think it was a big deal as long as his personal views did not influence his professional behaviour and ethics. But as some people have pointed out, he is the public face of an organisation that touts openness and inclusiveness as values. Furthermore, if I was gay I’m sure I’d feel more strongly about this, in the same way that someone who is non-white (or in the marginalised race) would feel strongly if the issue was around race as I've described above.
Finally, to people calling for him to apologise….him coming out with an apology to pacify everyone wouldn’t mean that he has changed his mind. It could just mean him saying what he needs to say to be able to get on with things while still harbouring the same thoughts and ideas within. Ask any politician.