I think that is a huge question.
I'm not certain that I agree with your assessment, and I think this is why it's very difficult to have much of a calm discussion in many areas, because inevitably the positions retreat to the same ramparts with fundamental divergences of opinions and interpretations.
You're always going to hear from the loudest elements of each party on any social, cultural, etc issue. I'm still trying to discern what the middle is in all of this, because it's a very difficult line to walk. I full-well admit I do not claim to know exactly where the line is even at.
However, the rub seems to be the full inclusion of LGBTQ+ in every aspect of ministry. It would seem that a middling position would be a way to give the parties each what they want, but the outcome it suggests would be a conservative wing on the church (on this issue) and a liberal wing. The conservative churches would be able to specifically not appoint LGBTQ+ people as clergy, but there would ideally be a level where they could safely participate in church life, perhaps even in certain lay roles (speaking as a Methodist). In liberal churches, it would be full participation.
I have no idea how you partition this out. Larger cities could obviously have one, or more, of the same denomination where one church functions in one way and another in the other. I would hope and pray that both sides could overcome their opinions of the other guys and gals and come together in other areas. The UMC local option would seem to come close to this, and it would at least offer LGBTQ+ the ability to walk safely and easily into any church. At absolute bare minimum, this should be a mark of a Christian church.
With that said, conflict over leadership is going to arise at some point, and I believe this is ultimately what is holding back the local option?
Lastly, where both sides retreat into the mantra of not compromising comes when the conservatives don't want to even fellowship with groups who ordain LGBTQ+. On the liberal side, the couching is probably a little better, but I've seen the word compromise be expanded to mean full assent or affirmation.