If I read you correctly: you were very drunk and told your top two levels of supervisor that you were transgender? Just a word of caution: Getting drunk with your supervisors is rarely a good idea. A sober discussion on the same topic might work or not, but a drunken one is fraught with bad o0utcomes.
Transgender desires unfulfilled are often associated with heavy drinking. Mine was! My wife finally made me see a doctor about it. I am not sure my wife’s desired results were: “I don’t drink anymore, but I am a girl!”
Seek transgender counseling, but also seek help to control the drinking, especially with your supervisory chain-of-command.