What the majority is saying is that there are certain personal rights that no government, on any level, can infringe. It is not a matter of liberal political correctness or favoritism to one group, since you are just as free to dislike homosexuality and/or refuse to engage in "sodomy" as you were before. Because the decision expands individual freedom, it's a huge victory for conservatives. It limits government intrusion into our private lives.
It's a victory for all Americans for the reason you outlined, except those Americans that are predisposed to snoop and snitch on their neighbors.
The busybody neighbor of these two gay guys who brought the suit to the SCOTUS just got told that they're an anti-American jackass.