What is the wisdom and purpose behind the 'aqīqah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
Among the wisdoms and purposes of the 'aqīqah are the following:
First: Expressing joy at the blessing of Allah the Almighty, rejoicing in the newborn, and giving thanks to Allah for this gift. Allah the Almighty says (what means): "If you are grateful, I will surely increase you." [Ibrāhīm/7]
Second: Proclaiming and publicising the lineage (nasab) of the child — and the 'aqīqah serves as an appropriate and fitting means to this end.
Third: Gladdening the hearts of family members, relatives, friends, and the poor by gathering them together over a shared meal. And Allah Almighty knows best.
What is the best manner in distributing the meat of the Aqeeqah?
It is better to divide all of it as cooked meat amongst the poor and the needy. Dividing it into three portions is a Sunnah, but it is permissible to keep all of it provided that a portion, even a small one, is given to the poor and needy (one kilo for example).
What should the one performing the slaughter say at the time of slaughtering the 'aqīqah?
All praise is due to Allah, and may peace and blessings be upon our Master, the Messenger of Allah.
It is Sunnah to say the following supplication at the time of slaughtering the 'aqīqah:
"Bismillāhi wallāhu Akbar, Allāhumma laka wa ilayka, hādhihi 'aqīqatu fulān."
("In the name of Allah, and Allah is the Greatest. O Allah, this is for You and unto You — this is the 'aqīqah of [the child's name].")
This is based on what al-Bayhaqī narrated in Al-Sunan al-Kubrā (Vol.9/P.511), that the Prophet ﷺ said: "Slaughter it in his name and say: In the name of Allah, and Allah is the Greatest. O Allah, this is for You and unto You — this is the 'aqīqah of so-and-so."
And Allah Almighty knows best.
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.