I have written about this many times, but one more time will not hurt....in fact, this post is another contradiction of more magical thinking
Only the perfect see God. Confession and the Last Anointing, according to the CCC, takes away sin, as Christ forgives us of our sins. But, these do not take away the punishment due to sin, or the time of purification necessary for those who die with imperfections and even venial sins. There are many references in the CCC, so look under sections 1499 on and 1020 on.
Remember, that the souls in purgatory are fixed in their sanctifying grace and cannot gain merit for themselves or others. Here is a statement from the Second Council of Lyons:
If those who are truly repentant die in charity before they have done sufficient penance for their sins of omission and commission, their souls are cleansed after death in purgatorial or cleansing punishments . . . The suffrages of the faithful on earth can be of great help in relieving these punishments, as, for instance, the Sacrifice of the Mass, prayers, almsgiving, and other religious deeds which, in the manner of the Church, the faithful are accustomed to offer for others of the faithful.
And from Trent:
If anyone says that, after receiving the grace of justification the guilt of any repentant sinner is remitted and the debt of eternal punishment is blotted out in such a way that no debt of temporal punishment remains to be paid, either in this life or in purgatory, before the gate to the kingdom of heaven can be opened: let him be anathema (DB 840).
The Catholic Church, by the teaching of the Holy Spirit, in accordance with Sacred Scripture and the ancient tradition of the Fathers, has taught in the holy councils, and most recently in this ecumenical council, that there is a purgatory, and that the souls detained there are helped by the prayers of the faithful, and especially by the acceptable Sacrifice of the Altar.
Therefore, this holy council commands the bishops to be diligently on guard that the true doctrine about purgatory, the doctrine handed down from the holy Fathers and the sacred councils, be preached everywhere, and that Christians be instructed in it, believe it, and adhere to it.
But let the more difficult and subtle controversies, which neither edify nor generally cause any increase of piety, be omitted from the ordinary sermons to the poorly instructed. Likewise, they should not permit anything that is uncertain or anything that appears to be false to be treated in popular or learned publications. And should forbid as scandalous and injurious to the faithful whatever is characterized by a kind of curiosity and superstition, or is prompted by motives of dishonorable gain (DB 983). more here
Some priests do not teach the Church's teaching on purgatory and assume all people go to heaven after the Last Rites. Such a thing was said today.
The apostolic blessing is plenary indulgence. A plenary indulgence takes away the temporal punishment due to sin, but not the sin, and therefore follows the Last Rites.
Here is the section from The Enchiridion of Indulgences:
The Moment of Death (In articulo mortis). PLENARY INDULGENCE. EXCEPTION TO THE THREE CONSTANTS. (Verbatim recitation of the grant follows:) "To the faithful in danger of death, who cannot be assisted by a priest to bring them the sacraments and impart the Apostolic Blessing with its plenary indulgence (see can. 468, Sec.2 of Code of Canon Law), Holy Mother Church nevertheless grants a plenary indulgence to be acquired at the point of death, provided they are properly disposed and have been in the habit of reciting some prayers during their lifetime. The use of a crucifix or a cross to gain this indulgence is praiseworthy." The condition: 'provided they have been in the habit of reciting some prayers during their lifetime' supplies in such cases for the three usual conditions required for the gaining of a plenary indulgence." The plenary indulgence at the point of death can be acquired by the faithful, even if they have already obtained another plenary indulgence on the same day."