How messed up is this?

Well I'm kind of a bitch so take it for what it's worth. But my response would be " so you consider me not reading your books as being unsupportive and you need or want my support? Well I need sex and want affection when you start caring about my wants and needs I will reconsider my position. "

Bravo! For standing up for yourself and "literally" having a voice. Your W pulled a DARVO (Deny Avoid Reverse Victim Offender) on you. 

1) She will continue to write weather you read them or not. ( there's money involved- that's the bottom line- and her escape from reality. She escapes giving you your required quality time and physical touch -men's top 2 love languages)
2) You are 'supporting" her financially, and with a long list of other household and family responsibilities, as well as giving her protection .
3) Romance novels are just that " a novel- a fake fantasy- far away from reality"  typical of an avoidant who will always push the blame on others. What's the saying? " when you point your finger at someone else, there's 4 fingers pointing back at you!"

Good gravy!!!
That's a huge tease that would sadden then anger me because she is creative. Do you have a sexless background that you would like to write about?

Why don't you care enough about me to support what's important to me? Sex is a sweet loving act that's really boosts my confidence...the intimacy makes me feel wanted and loved. Instead of rejected and pushed away...fill in the blank

I find this proven time and again.
It doesn't mean anyone is bad at sex or unattractive.
It doesn't mean that love, in some form, isn't present.
It's improbable that someone "forgets" how to express sexual desire for a partner, nor that the importance of it in a relationship is lost (usually there are daily reminders from a spouse).
It certainly doesn't mean indifference toward sex in general. You don't put your whole marriage and lifestyle on the line with indifference. Indifference could lean just as hard into "why not?"
Most of the time, once the affair is revealed, or the relationship opened, or the "sex-averse" partner finds his or herself in the dating market again, there is a self-discovery and sex returns to that person's life.

Usually, the lack seems to mean that there is such a fundamental disconnection between a couple that one of them has ceased to see the other as a viable sexual partner.
Think of someone - anyone - that you know, who might be attractive enough but that you wouldn't ever touch or want to, based on something you know about them that you didn't always.
It's a harsh toke, because most of the time, it's not really like you can "unknow" something, or rewind on whatever formative experience developed with them that turned you off them enough to override your own healthy libido, rather than have sex with them.

Supporting your wife with writing and being a fan?
Strikes me as a separate idea.
Maybe to her to both of you, these are related

The sex dried up before the writing started and even now she doesn't ever pleasure herself. As far as I can tell, she's become asexual.

As far as you can tell, sure; however, if you are a person who she doesn't wish to include in sexual intimacy, she's really unlikely to share that with you.

Suppose it's true that she doesn't do that alone... that doesn't change things much. As a divorced dating man who has dated many separated and divorced women, I can say that's it's a normal and expected revelation that at some span across the latter years of a relationship, one of the partners either seeks an outside sexual dalliance or, it expresses itself as a disengagement from sex with a partner entirely. If the person doesn't wish to cheat, then it would present as a distinction without a difference from aesexuality. In my own prolific dating career, including what I know of my own ex-wife - it's more common than not for the sex-averse person to "discover" sexuality again in a subsequent relationship - the same sexuality they had when you met. Depending on how honest they are with themselves, it may be as much a surprise to them as to you.

I'm only explaining this so you can test this in your own situation and hopefully save time and heartache.
If you do what I did, and what most people do - treat her disinterest as some sort of sexual dysfunction that needs to be restored to functionality, rather than the result of a fundamental shift in the way she sees you or the relationship - then you could waste a lot of time trying to correct something that is unlikely to work. She has to want to do it.

The facts on the ground - what you DO know - is that she does not wish to have sexual intimacy with you.
So, you need to figure out for yourself what the nature of your relationship is?
Does a marriage include sexual intimacy? Would you - did you - both agree on that?
If you don't have it, then you need to figure out whether what you actually have is a marriage, as you both agree a marriage to be.
Are you committing to celibacy?
Because essentially, you are both in the same situation - bound into an idea of a marriage and both choosing to override your sex drives to continue the household format of a marriage -both of you in a sexless marriage.