The Supreme Court has decided that every state must make provision for same-sex marriage. This is a legal decision. It is not a decision about morality or religious belief. Thus, it has no impact on what the Catholic Church understands to be the mind of God about marriage, nor does it affect how the Church will teach and act with regard to marriage.
Although the Church cannot accept the concept of two men or two women being married, we nevertheless respect those persons who experience same-sex attraction. Like everyone else, they are children of God whom Jesus came to lead to eternal life. Following Christ is a source of great joy; it is also, for all of his disciples, a call to sacrifice.