Well first of all, this is not a central dogma of the Church. It is not officially infallible (no ex cathedra), so it is open for debate. It also comes from my interpretation the Social Justice teachings.
usccb.org/sdwp/projects/socialteaching/excerpt.shtml
I view this as an issue of human decency. That we are singling out a group unfairly for a part of their being they have no control over. That single thing is not in itself means exclusion from anything. It is my personal solidarity with a group that has been labeled a virtual outcast by others on this one thing.
Somewhere the official stances are stickied, and they do say love the person, but then the rest of the institutional actions tend to run counter to that teaching. Some of it also comes from the timing this “teaching” started to be focused on, soon after the hiding and moving molesters scandal, so I also view this as a unfair type of scapegoating from above, as homosexual and molester are not one synonyms in terminology. (It is possible to have both but it is not a hard and fast rule).
Right now the issue is also only in civil circles, not Church circles, and has no effect on the Sacramental marriages performed by the Church. They are free to do what they want. Families are not broken up solely on what their neighbors do. I believe anyones marriage bond is much stronger than to have something like this break it up, otherwise it was a bad union to begin with for other reasons.
In this and the adoption issue, I look at the entire person. (Of course some same-gender couples are not meant to be together, but for the same reasons different-gender couples are not meant to be together). And sexual preference is not an automatic red flag as it very rarely defines one person’s being.