Is the father a Mahram (Non-marriageable) to his son`s mother-in-law?
The father is a non-Mahram (Marriageable) to his son`s mother-in-law, so it is impermissible for them to look at each other, or to have a seclusion (Khalwah).
What should a person who was favored from Allah with a newborn, but couldn`t afford an Aqeeqah, do?
Aqeeqah (the sheep slaughtered on the seventh day from the child`s birth) is a desirable Sunnah for the financially able since Allah, The Exalted, charges not a soul beyond its capacity. Therefore, if the father couldn`t afford the Aqeeqah before the end of his wife`s confinement, then it isn`t due on him, and if he was able to afford it later on, then it is permissible, but if he didn`t until the child reached puberty, the latter can offer the Aqeeqah himself.
Is prayer mandatory on a dying person who goes through a state of unconsciousness, then wakes up?
If he wakes up and was conscious, then he should pray the way/manner he could, but if he wasn't, then he is exempted from obligatory prayer as Allah Says in this regard (What means): "On no soul doth God Place a burden greater than it can bear." [Al-Baqarah/286].
Is it permissible to offer prayer at home, or should it be offered in the mosque?
All perfect praise be to Allah, The Lord of The Worlds. It isn`t preferable for the man to pray at home as praying in the mosque is twenty seven times more rewarding. Therefore, this should motivate him to offer prayers in the mosque. And Allah Knows Best.