When I saw that it was an article by Jana Hocking, I was about to dismiss it. Anything by her and Mary Madigan I don't bother (Jana giving relationship advice when she can't hold down a relationship and sleeps around as much as she can, and Mary because she just generally hates men; a modern feminist).
But figured, what the heck, I'll read it since you posted it. Turns out the advice isn't from a woman telling men to treat a woman like a queen - the advice is from another man. Perhaps there is some truth to the advice of Alain but I don't think that is all there is to it. I think women just become comfortable in their relationships amongst other things that they lose sexual attraction for their partners. It is often said that men have built a comfortable world for women so much so that men have become expendable.
I'm not partnered so I can't try the suggested solution "How have we annoyed each other"?
Anyone care to try it out and report back? If your partner asks why, maybe insist on an answer before revealing why. Once you have the answer, share the article and see if it makes any difference to her attitude and your sex life. If anything, rather than suffer in silence, it will show her there is an issue boiling under the surface. She can then decide to action or ignore it. At least you then kinda know where you (and her) stand.