Do you just periodically attempt sex? I feel like attempting sex and not having a good experience is negative reinforcement. It ends up making you less likely to attempt next time.
To be honest, my own personal experience has been that I can have sex when really drunk but am now afraid to start...