2 days after my progressed Venus went into Cancer...
Hey! Coming from a Sun/Moon/Venus in Cancer, I know the struggle of sensitivity. ALL THE FEELS. Luckily, I'm a bit Jupitarian so I manage to bounce back eventually.
I had a similar experience with my last ex who was Virgo Sun, Scorpio Moon. Before we committed, he told me that he wasn't sexually attracted to me... after we had multiple sexual encounters. It was weird. It actually colored the entirety of our relationship because it made me insecure. I'm in a relationship with someone that doesn't even find me attractive.. wtf? It messed with my mind a bit. He reassured me that he didn't mean it and that he had made a mistake, not sure if it was true or not. Maybe he just wanted to push me away at the time. We had a great relationship at times and a roller coaster at other times, partly due to my sensitivity and him pushing me away occasionally due to his own moodiness. I got a bit clingy and expected a lot of emotional connectivity which he had a hard time reciprocating, but wanted to learn and tried. He was the backbone of his family and learned at a very young age to compartmentalize emotion to the point of rarely acknowledging it. It eventually ended during COVID because a lot started to surface and the cracks became real so I ended it.. which I sometimes feel so sad about because I loved him. Now he's getting a house with his new partner. I'm happy for him though.
After the relationship, I learned to be a little bit less clingy and sensitive. Learned how to let go, have more thick skin, have a bit more fun and be okay with just being nonsensical sometimes for the sake of having a good time because of him. He told me that I taught him how to take care of himself, be more empathetic, to feel, and to open up more. He told me that I was the sweetest person he's ever met and that I should never change because my heart is the best thing about me.
So Venus in Cancers definitely has its pros and cons. I agree with Dori on that it can be beautiful having such a big heart and caring nature. Being empathetic due to such sensitivity is also a beautiful trait because you will always be able to connect with others emotionally and be able to understand the depths of people and situations that others cannot. I would agree on learning how to navigate your sensitivity, like your triggers, where they stem from and learning how to tell that little voice that you're okay, you're strong and whatever hurt you won't be the end of you. And that it's okay to FEEL as long as you can be able to eventually let it go. Holding onto it only hurts more.
I hope this helps <3