You mean like Ted Kennedy and Chavez, who *repented* at the end and got their Catholic church blessed funerals?
I seriously doubt either of them repented at the end.
I also suspect they ultimately came to regret that decision.
The Catholic church, though founded by Jesus Christ, is operated by human beings, some of whom have sold their souls for earthly rewards.