In regards to transgender athletes competing on women's teams which has already been found to violate Title IX -- this Biden EO is little more than virtue signalling. I don't know about the ramifications outside of this particular narrow area -- employment, etc.
Been reading a few of the EOs and they say a whole lotta nothing (no teeth). Take a look at the DACA one for a good example.

