Without knowing you personally, the dream you describe is one of a housewife who feels powerless and that her only worth is in her health and her ability to do housewifing and mothering. Cancer would certainly inhibit that ability.
Not being picked up after you are better is indicative that you feel you can be easily dismissed and ignored by your loved ones. You fear that nobody
really loves you or cares about you.
The part about your husband taking a new girlfriend and treating you like garbage by rubbing it in your face is your deep-seated fear of being
replaced easily. This is not necessarily a silly fear, as plenty of men do this.
Your dream highlights the issues that all stay-at-home mothers have: We have no economic pull, we have to ask our husbands for every dime, and since
hubby is gone at work for many hours, we don't know what he is up to. We fear that we are worthless and easy to replace.
These are all valid issues, painful issues, and if you continue to have these types of dreams, I would suggest some counseling, along with taking up a
hobby or something that gives your life more meaning and gives you more time to grow and develop as your own unique person.