It isn't so much sexual preference but the availability of employment for any person >40 in NYC that is going to be your worry.
Just as with the straights the gay community in NYC is very much divided into them that got versus them that don't. For every Michael Kors or Neil Patrick Harris or even the gay couple in in this link there are perhaps three or more "poor" just like everyone else, trying to keep on keeping on in a very high COL area.
Beautifully Renovated, 1840-Built Chelsea Home Asks $16.5M - On the Market - Curbed NY
Do not let all the hoopla about equality and gay marriage in NYC/NYS fool you into thinking this place is some sort of heaven. While perhaps better then Podunk City USA there is still discrimination against gays. This can and is often heaped on top of racial, ethnic and age bias as well.
It is difficult for many older (and we are talking anyone >45 or so) persons to find work in NYC, and things do not always get better at 50 or over. What sort of educational level and employment background do you guys have? What sort of employment are you going to be seeking? Do you all have any savings to live upon until work is found? Health insurance?
If you have not lived or even visited NYC before be prepared for a culture shock of just how much it costs to live here. Even in a "communal" setting unless you manage to find a squat somewhere you will likely find your share of expenses is probably more than you budgeted unless you know the lay of this land.