I would say it's generational. I'm retired. Everyone that I know who's a contemporary of mine (and has voiced an opinion either way), didn't support the repeal. I think as you descend into the lower ranks, the service members are generally either more supportive or perhaps ambivalent or even indifferent about the repeal.
My personal estimation is that if the repeal has any effect at all on recruitment, it will be negligible at best. That is a wholly separate question about whether or not it will have any negative effects on good order and discipline. I think that it will.
I have one question. How is the military going to handle HIV?