There is a saying that "the only way three people can keep a secret is if two of them are dead."

OTOH, I told the wife of a close friend (and not the friend) because they have a Trans child and I thought I might have some knowledge about Transgender issues that would help her deal with their nonbinary child. The wife appreciated my honesty and it could not have turned out better.

My phone outed me to my wife's best friend. Has not been an issue.

There are others who know the male me who know I dress. It's not been an issue.

But as with the others, I would not confide in a direct report, unless you were to disclose to HR and ALL your direct reports. Not a good idea.