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.
Should a person feel pleased, or have a virtuous vision after offering Istikhara (guidance prayer) in order to do what he/she had offered it for?
The result of the Istikhaarah is not necessarily that a person sees something (in his dream), or feels pleased, but the most important result of the Istikhaarah is whether a person is enabled to do a given matter or not.
Is it permissible for one who sacrifices on behalf of another, with the latter's permission, to eat from the sacrifice?
It is permissible for someone who sacrificed on behalf of another with their permission to eat from it with their permission, and they stand in their place (act as their representative) in distributing it.
It is stated in Nihayat al-Muhtaj ila Sharh al-Minhaj (Vol.8/P.141): "And he—meaning the one sacrificing on his own behalf, provided he has not apostatized—has the right to eat from a voluntary sacrifice and his sacrificial gift; rather, it is recommended. As for an obligatory sacrifice, it is forbidden for him to eat from it, whether it was designated as such initially or as a liability in his dhimmah. And excluded by what has preceded is if he sacrifices on behalf of another, or if he apostatized, then it is not permissible for him to eat from it, just as it is absolutely impermissible to feed a disbeliever from it."(The text I found indicates the impermissibility of eating) ???
And it is stated in Hashiyat al-Jamal ‘ala Sharh al-Manhaj (Vol.5/P.262): "If a person offers a sacrifice on behalf of a living person with their permission, does he act as their representative in distributing it—on the grounds that permission to sacrifice is permission to distribute it—or does it depend on their explicit permission? This requires consideration, but the first view is not far-fetched." And Allah the Almighty knows best.
How does the person praying perform the prostration (Sujud)?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
It is an act of Sunnah for the person praying to descend for prostration (Sujud) by placing their knees first, then placing their hands on the ground, and then placing their nose and forehead simultaneously. It is obligatory that the toes of the feet be on the ground, directed towards the Qibla. And Allah the Exalted knows best.