Hi, LoboLobo,
What you are presenting, I think, would be called a ‘convenience sample’ - you looked around and saw some positions and then formulated a hypothesis. At the very least, the issue you have here is based on insufficient sample size. Unfortunately, this is NOT the real issue: The Catholic Faith is not based on a ‘show of hands’. Notice in Matthew 16, Christ did not make a motion to have Peter lead the Apostles and receive the Keys to the Kingdom. Christ did not ask for a vote for Peter. After Peter’s denial - the Apostles did not gather to have a ‘No Confidence Vote’. What we have is a religion of Faith, based on the Authority of God - and not the traditions and votes of men.
As the late Bishop Sheen said, “just because everyone believes something, does not make it true…”

If all of the US Catholics that formed part of a national sample (no question about size or bias, here…) said that they did not opposed homosexual behavior - all that would mean is that we have a lot of US Catholics who either do not know or refuse to believe the teaching that homosexual behavior is inherently disordered - and gravely sinful for those capable of sin.
It really makes no difference (except for the pulbic scandal it gives) for a priest to allow homosexual behavior in his parish or to endorse homosexual behvior in opposition to the teachings of the Catholic Church. Note: Luther was a priest and he went off the deep end in promoting heresy (e.g., Sola Scriptura). Just being a priest does not immunize anyone from straying from the path.
God bless