I certainly don't wish for death, I still find so much beauty and joy in life, and I still find and experience love. But I don't wish for an afterlife, or prolonged life. If I'm fortunate to live until my natural death, I will welcome it.
Humanity will go on, there are billions of threads of consciousness right now, and I feel so much gratitude that I was and am one of those. I have a lot of comfort in being wrapped and surrounded by those threads, and that they will continue around me when mine frays and ends.
My cannon view is that we're just the universe experiencing itself, and that while my consciousness will end, that universe will go on, my atoms part of it.
So this makes me think that from moment to moment, as we pass through time at one second per second, it's as if we're being sent through a transporter. That is to say, if in the far future after my death I am reassembled, or even if just a close imitation of me is assembled from whatever data they can get hold of, then that would be no different from me, or Bernard, being brought back to life. "I am Bernard", he would say, and he'd still be right. Of course other Bernard wouldn't get to share his experiences, but so what. My former self can't share my present experiences.
So, why hope for this to happen at all? It has to be that what we're emotionally invested in is not really "continuity of experience", which is a myth, but continuity of ideas. It's nice if those ideas can sit together in the coherent context of a mind. The Woody Allen quote is "I don't want to achieve immortality through my work; I want to achieve immortality through not dying." But perhaps in fact through your work is good enough, really? Like a close second.
What I mean to say is, I don't so much hope for an afterlife, as to discover that it philosophically doesn't matter anyway. Though I prefer people not dead.
When there is an afterlife or perhaps even eternity, the problems begin.
Imagine taking sports coaching from one who never played…
I feel that eternity in Heaven would actually be Hell, because nothing would matter. No danger, no failure, no challenge, no goals, no purpose. What gives life meaning are mortality, limitations, beginnings and endings, progress.
I recently watched the film "Eternity" on Apple TV, starring Elizabeth Olsen, in which everyone after they die has to choose their own form of afterlife and then stick with it forever. All I could think about was how bored I would eventually get. (The film itself was pretty good, not boring. That's because it had an ending!)
Fiction is ideal for playing out these scenarios. Think also of the film "Highlander", in which the ultimate "prize" of the immortals turns out to be mortality. MacLeod's life had become repetitive, and he couldn't fully invest in it, because he kept losing everyone he loved. They grew old and died, while he lived on and had to keep changing identities. For a while it's a grand adventure... until it isn't anymore.
I can certainly understand wanting to live longer, but eternity is unimaginably long, way too long. I don't think that's something to be desired.
(Edit: probably an embellishment of Archimedes, supposedly saying to the Roman soldier who killed him, "do not disturb my circles!" - not exactly a plaintive attitude about mortality, more just being a grumpy geometrist.)