There's many good reasons for society to fail to give an imprimateur on many sorts of relationships. In this case, whether or not one likes it, it's quite clearly the wish of the majority that homosexual unions not be given the identical status of heterosexual marriages. Changing that, should be changeable, will be a matter of persuading people with far more effective agitprop than "it hurts PEOPLE," assuming it's possible to be done at all. At present, laws like DOMA can reliably be counted upon to pass with huge majorities, including the most reliable leftists to be found in the United States Senate.
Re: Paul would have disagreed
I guess that's the President's fault, too.