And is anyone on this thread is saying they should not be supported or helped to move beyond whatever rigid thinking made them believe their mind was incompatible with their sex? No. All anyone is saying is that that support cannot include cross sex privileges, which it never should have done.
As a member of the psychology community, I'm sure you must have come across other situations where one person's "solution" to their pain causes them to damage someone else. Do you just sacrifice one to the other? No. (I hope) you help the damager to find a better way, and the victim to understand that they are not obligated to endure this damage out of sone misguided idea of loyalty, guilt or moral expectation.
As a member of the psychology community, I'm also sure you have come across people, maybe genuinely damaged people, who have learned to leverage the threat or even the act of self harm to get them what they want. Clearly that's not the act of a mentally healthy person and such people deserve sympathy and help. But they also need to accept that manipulative behaviour like this is coercive and unacceptable, and that ultimately it is no one else's job to be the outsourced keeper of their emotional stability.
So again I'm not sure what your point is. Will many be put in a hard position? Yes. Should transphobia, real transphobia that manifests itself as exclusion and abuse and may feel itself enabled by this EO be stamped on hard? Yes. Should there be help and support for those misled by the transition industry? Yes.
And that is a great opportunity for your community to stand up and show a better way to deal with these feelings than a false transition, and indeed for the countless trans rights groups and organisations to get stuck in and do something concrete and meaningful that actually moves society forward in accepting and valuing the wide variety of human personalities instead of fighting against a problem they themselves inflamed by embracing the rigid and sexist concept of gender transition as the only possible solution.