So, I have been in situations like this.
One situation I went to a bar (in college)
Met a guy, danced with him, made out with him. After a few drinks I brought him back to my place and made out some more.
I got triggered though (as I have many times before) and said, "no."
Did I really want to have sex on some level? Yes. Was I even turned on? Yes. But I got triggered due to the fact that I have issues with penetration from child sa.
I said no.
But the guy got pissed. He then changed and there was a look in his eyes. He became angry and pinned me to the bed. He acted entitled and was angry at me because I had indicated to him that sex would happen and then I changed my mind (got triggered).
I was being pinned and I was thinking back to the self defense class I had organized as an RA in the dorms and how I had been pinned by my girl partner (who I am pretty sure was on the rowing team) and how I pretty much sucked at getting out of being pinned.
I knew I was about to be raped.
But then my roommate came home and this snapped the guy out of whatever state he was in.
I then told him, "Get the f*ck out of my apartment." I made him wait out on the curb for his cab.
Another story, similar to this, met a guy at a club, danced, made out brought him back to my place. We made out some more. He wanted to try oral sex, I got triggered, said no.
This guy then said, "Ok, I understand." And I made him some tea and we talked for a couple of hours.
I always blamed myself for that first scenario.
That I was a tease, that I was stupid. But my T says that the second scenario with the understanding guy should be the expected outcome.
So, especially with a history of sa you can want it and not want it. What is important is that you can change your mind.
It is a total red flag for him to insist even drunk. Sure a guy may feel frustrated, but should be showing you complete respect. My husband has dealt with this with me and he actually gets immediately turned off by me saying no, which makes sense.
Honestly, to the OP's question, if you are in a relationship and your partner handles you being triggered with complete respect this actually can help increase the intimacy and safety leading you to work through your triggers and to be able to have sex. Also, therapy can help with sexual triggers.