I think what complicates this is that there are a few issues that are often concurring:
1. People receive messages from society, friends, or sexual partners that they "should" be able to perform in a certain way, or feel a certain way about sex. These messages can be shaming both to people with low and high sex drives, and there are a lot of biases and assumptions about how men and women relate to sex. For example, the idea that women are more interested in sex if it's part of a loving relationship, or are less interested in having sex to achieve orgasm.
2. The ways female-bodied people enjoy sex aren't always obvious considering sex education in the U.S. often isn't very comprehensive and there's a lot of focus on intercourse at the exclusion of other kinds of sex. I think there's an expectation that intercourse will be pleasurable. But not all female-bodied people enjoy vaginal penetration, or can enjoy sex with just that. Historically, there hasn't been much encouragement for women to experiment.
3. Some people know their bodies and want to have sex more than they do, but honestly can't get their bodies to cooperate. This is when drugs might be helpful for some people. And the first two issues don't mean that this issue doesn't exist at all. Wanting to do something doesn't always mean that you feel like you can, or that your body is on the same page with you.
There was some comparison to wanting to write, and yeah, actually, there are a lot of times when I want to write but have trouble focusing.