considered opinion of a majority of Catholics is one of acceptance for the LGBTQ community...and that opinion matters, because Church "Doctrine" is not "Dogma"...it is a 'current' teaching, and doctrines/teachings have been changed before...(see following link)
https://www.irishtimes.com/opinion/history-shows-the-church-has-changed-its-moral-teachings-1.437230
I submit that such a process is underway as we speak with regard to the LGBTQ issue, and the polls bear that out. Pope Francis has shown that even the highest levels of the Catholic Church can be open to a new doctrinal teaching. It won't happen tomorrow, for sure, but don't be surprised if the tide of public opinion doesn't win out eventually. Guaranteed, some members of the Church will be unhappy...hopefully, they will see the 'goodness' in that teaching...
BTW, surprisingly, even the Southern Baptists have heard the call to a more progressive view and elected leadership that reflects that perspective....they are human beings too, so why can't the Catholic Church go in that direction?
Link: https://www.hrc.org/resources/stances-of-faiths-on-lgbt-issues-roman-catholic-church