Every woman eventually goes through menopause but it doesn't mean it's the end of their sex life! Most women if they are dealing with an issue that makes sex uncomfortable seek out medical advice.
In addition the drug Flibanserin has been approved by the FDA to treat premenopausal women with low sexual desire.
Some women have been known to report that they enjoyed sex more after going through menopause.
There is no need to have a "sexless marriage" unless that's what (you) want and even then it may cause your husband to eventually stray. Most married couples don't plan or want to be sexless.
“While we are free to choose our actions, we are not free to choose the consequences of our actions” – Stephen R. Covey