just look at all the recent polls about same-sex marriage. If they are ok with that (and most are) then I doubt they care if the President is gay. We have an openly gay/lesbian Senator now (Wisconsin) and an openly bisexual Representative(Arizona). Times they are a changing....or rather they have changed. Keep up!
I personally don't care one way or the other whether he is or not. I do know many gay Catholics, however.