What should one who forgot to offer the second Sajda during congregational prayer, and remembered it before the end of the prayer do?

All perfect praise be to Allah, The Lord of The Worlds.                                                                                                                                                          Whoever forgets a pillar of prayer while in congregation must follow the lead of the Imam, and after the latter offers Tasleem, he should offer one Rakah, then perform Sujood As-Sahw (prostration of forgetfulness). And Allah Knows Best.

Is it permissible for a pious Muslim woman to stay with her husband who had quit praying out of laziness?

Quitting prayer is one of the major grave sins that come after disbelieving in Allah, but the wife of such a person isn`t considered divorced, rather, she should exert all her efforts in order to bring him back to the way of Islam. However, if his sin is likely to lure her from the way of Islam, then she had better separate from him by lawful means such as Mokhal`aa (When a wife pays a compensation for her husband in return for divorcing her). Moreover, if she exercises patience, and remains steadfast on her faith, then there is no harm in doing that.

What is the ruling on staring at the Holy Ka'abah?

All perfecy praise be to Allah, The Lord of The Worlds and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions.

Staring/looking at the Holy Ka'abah is an act of worship even if this took place while performing a prayer, since Al-Baihaqee stated that the Prophet (PBUH) said: " Staring at the Holy Ka'abah is an act of devotion." [Sho'aab Al-Imaan]. And Allah Knows Best.

Should a prayer performer who forgets to offer the middle Tashahod (saying ash-hadu anala ilaha ila-alah) offer Sujood As-Sahw (prostration of forgetfulness)?

He/she should offer two prostrations of forgetfulness at the end of the prayer. And Allah Knows Best.