There’s a phenomenon known as “arousal non-concordance” which is discussed in Emily Nagoski’s book Come As You Are, probably the sex book I recommend to people most often. Arousal non-concordance is a mismatch between your level of physical sexual arousal (erectile tissues swelling, presence of pre-cum or vaginal lubrication, etc.) and your own subjective assessment of how aroused you are.
Arousal non-concordance is said to be much more common in women than men. I think there are a variety of reasons for this. One might be that women are societally encouraged to view ourselves as sexual objects rather than subjects, and to view it as more important to be desired than to express desire, and so we may not be as directly or regularly aware of our own desires and what they feel like in our bodies. Another reason is that we are statistically more likely to be survivors of sexual assault, and it’s scientifically well-established that sexual trauma can contribute to a feeling of dissociation or disconnectedness from one’s body.