When Kathy died, I did not put Psalm 23 on the eulogy. I put 1 Thessalonians 4:13.
"But I do not want you to be ignorant, brethren, concerning those who have fallen asleep, lest you sorrow as others who have no hope."
I wonder if we, even as Pentecostal believers, pray for the sick like those who fear death and dying. We feel the need to visit the dying person, like we will never see them again. We pray earnestly for their healing, like we are afraid of getting sick and dying. Our theology is more Roman Catholic than protestant Pentecostalism. We somehow think that we must pay now to play in Heaven. We think that suffering now guarantees a pain free life in Heaven. This is not Bible doctrine.
We get to Heaven by believing in Jesus Christ. We are saved by faith, not by works, lest anyone think they deserve it.
"For by grace you have been saved through faith, and that not of yourselves; it is the gift of God, not of works, lest anyone should boast." Ephesians 2:8-9
According to James chapter 2 we can tell what kind of faith you have by observing how you live. How you treat the dying and the terminally ill tells a lot about what you believe about eternity.