I was raised mormon, live in utah, and a majority of people i actually know are mormon or have been a mormon at some point in their life.
Most of the people i know - their reactions range from having difficulty accepting it or visibly having a hard time rationalizing it, to just being flat out disgusted and enraged by it.
What a lot of people don't understand about mormons is that the LDS church really is run like a railroad company. It is strictly top down authoritarian.
You may be thinking, ok but catholics are authoritarian too? Not nearly in the same way.
The pope leads the catholic church, but there is clear and open dissention in the ranks. There are powerful people in the catholic organization who really have a problem with Francis and the way he is doing things, and they aren't really shy about saying it. Even the cardinals, who are very close to the pope's power structure both organizationally and physically, fall over themselves to try and spin what he says in a more traditional way.
That doesn't fly among mormons. Dissent will get you kicked out. Not being able to agree with something that comes out of salt lake city is a problem that you have and you need to solve.
Catholicism has factions for crying out loud. If you want to have a mormon faction you have to resign your membership and start your own separate church.
Additionally, it is explicitly clear that the local leadership exists to represent the central leadership to the local membership, and not the other way around. This is clearly written in the handbook.
As a member of the mormon faith, you literally and explicitly have no say.
So, I would say that a large number of faithful mormons are having a really hard time coming to terms with this policy change. Possibly as many as half the membership.
It's difficult for numerous reasons. Chiefly among them, that "love the sinner, hate the sin" doctrine is actually taught in mormon sunday school. And also in large part because, as it's worded, it appears to punish children for stuff their parents did, which is really beyond the pale.
There have been some really fraught rationalizations that this somehow "protects" children from having the church drive a wedge between them and their parents by teaching them that their parent is apostate, but even in the last week it has been clear that it works pretty much precisely 180 degrees from that.
For example, one mother of two reports that her bishop went out of his way to inform her that if either of her two lesbian mothers visit with her children, she will be subject to mandatory discipline.
And that, frankly, is pretty messed up.
There are noises about mass "resignations" from church membership but if it amounts to more than hundreds of people i will be surprised.
As for myself, I'm beyond caring what religious people believe, least of all what they think about whether i am part of their church. I can find no meaning in the act of filling out some paperwork so that a meaningless field in a database somewhere in salt lake city changes from one pointless thing to some other pointless thing.
I don't care if they think I'm still a member. They can think I'm a duck. Doesn't affect me one way or the other.
I just hope the nice elderly couple that does outreach in this neighborhood comes by to talk, because then I'll have to explain that my personal morals and ethics don't allow me to associate with hate groups.
As for the brethren in salt lake city - since the days of brigham young (and possibly not during the days of joseph smith) there has been an Official Stance that the Brethren Are In Perfect Concordance. And this has always been an absurd distortion of the truth.
The reality is that they put forward a unified face at best, and at times that are less than the best, many members of the leadership simply hide their face.
My guess is that someone pushed this through with minimal oversight, and now the church is stuck with it. Because mistakes are impossible.
Some of them are culture warriors. Some of them are frightened old men who don't understand the world around them. Some of them are genuinely nice people.