He may not have been into women, but that doesn't make him "gay". He simply could have been asexual or not that much interested in intimate relationships. It was the latter, I think. What's wrong with that? Besides, when you're a captain of a Federation flagship you don't have much time for those things.
(that's when he is begging him... but taken out o context it looks like something else:-)