Church Doctrine is Church Doctrine. Polling over the last few decades is entirely irrelevant to that. I assume you agree with this. So, what point are you trying to make regarding polling? There is no "both sides of the debate" when it comes to Doctrine. There is only those who embrace the entirety of Catholic Doctrine, and those who do not...and the latter do not speak for the former. Meanwhile, Catholic Doctrine abides independently of all of that.
Side point: I look at this not as a rights vs. rights case. The civil/secular right of homosexuals to engage in homosexual behavior was never questioned or challenged by the Church. Rather, this was a power vs. rights case. The issue was whether gay activists could use the power of government to coerce a religion to condone the views which were antithetical to the religion's doctrine. (You can argue with me on this, but even liberal justices agree with me.) Today, rights won out over powers, which is as it should be, of course. The sole purpose of a right is to stop the exercise of power against that right.