Women aren't a monolith, just as men aren't. There are women who will appreciate your emotional openness, especially if you are able to regulate and communicate those emotions in a healthy way.

Edit to add: my relationship to my husband has only grown deeper as he has learnt to better access and express his emotions. In particular, he is working on accessing emotions other than anger, and this has really helped us grow our connection.