Both the male and the female were created for the purpose of worshiping Allah (swt):
(Every Quran verse will be in the M.M Pickthall translation)
I created the jinn and humankind only that they might worship Me.
and both were placed as "khilafah" on Earth:
And when thy Lord said unto the angels: Lo! I am about to place a viceroy in the earth, they said: Wilt thou place therein one who will do harm therein and will shed blood, while we, we hymn Thy praise and sanctify Thee? He said: Surely I know that which ye know not.
This is a reference to humankind (males and females) as in the Quran both Hawwa and Adam were placed on Earth at the same time
The most revered women in Islam is Maryam bint Imran
And she is the only woman mentioned explicitly by name in the Quran.
Maryam was a 'waliyah' according to Imam Razi (the best translation is saint) and interestingly enough, Ibn Hazm and Al Qurtubi believed her to be a prophetess
Regardless of what exactly she was, she is known by all Muslims for her piety and faithfulness
Quran 3:42 :
"And when the angels said: O Mary! Lo! Allah hath chosen thee and made thee pure, and hath preferred thee above (all) the women of creation."
Quran 3:43 :
"O Mary! Be obedient to thy Lord, prostrate thyself and bow with those who bow (in worship)."
"And Mary, daughter of 'Imran, whose body was chaste, therefor We breathed therein something of Our Spirit. And she put faith in the words of her Lord and His scriptures, and was of the obedient."
None of the verses quoted connote that she was good because she gave comfort to her nonexistent husband but that she was good because of her iman and submission to God
Maryam also has titles in Islam:
Qānitah - The Arabic term implies the meaning, not only of constant submission to God, but also absorption in prayer and invocation
Siddiqah - She who confirms the truth or she who has faith
Sājidah: She who prostrates to God in worship.
Rāki’ah - She who bows down to God in worship.
Tāhirah: She who was purified
Mustafia: She who was chosen
Sa’imah: She who fasts
Again her titles reflect that she was great because of her ascetic nature and devotion to God
As well as that men and women have the same religious obligations in Islam and are spiritually equal:
Quran 9:71 :
"And the believers, men and women, are protecting friends one of another; they enjoin the right and forbid the wrong, and they establish worship and they pay the poor-due, and they obey Allah and His messenger. As for these, Allah will have mercy on them. Lo! Allah is Mighty, Wise."
Quran 33:35 :
"Lo! men who surrender unto Allah, and women who surrender, and men who believe and women who believe, and men who obey and women who obey, and men who speak the truth and women who speak the truth, and men who persevere (in righteousness) and women who persevere, and men who are humble and women who are humble, and men who give alms and women who give alms, and men who fast and women who fast, and men who guard their modesty and women who guard (their modesty), and men who remember Allah much and women who remember - Allah hath prepared for them forgiveness and a vast reward."
If women were made for the purpose of comforting men then surely that would be their sole religious obligation