>I became a little overwhelmed at the reality that myself and all of my relationships will be gone and forgotten once I pass...
>
>I have the luxury of pushing it out of my mind, but one day I may not be so lucky.
You've got the "problem" framed very well! Very understandable that this sort of musing can cause trepidation.
I'll first point out the obvious: when you die you're not going to be around have a problem with any of it; so there is no problem with it :) But let us move on to more eloquent discussions of the matter...
There are many other ways to frame/understand the situation. One of my favorite commentators is Alan Watts. He discussed death many, many times and you can find all kinds of talks on YT. I can't remember which lecture this excerpt is from, but it was one of the first things I ever heard from him and it's remained a favorite down through the years:
https://www.youtube.com/watch?v=mMRrCYPxD0I
Text form:
https://genius.com/Alan-watts-the-real-you-annotated
Again, apologies for my lack of recall of exact lecture context, but he discussed the perspective of death being a cause for celebration: "...you're gonna die, and it's going to be great! You won't have to work any more, you won't have to pay any bills any more, you won't have to worry about anything any more..." in the context of what he playfully called "the Institute of Creative Dying:"
http://www.reflectionsonsunrise.com/2014/03/02/institute-for-creative-dying/
There are many other examples of him touching on death in very meaningful ways.
But my all time favorite treatment of this topic is is found in The Pilgrimage by Paulo Coelho:
https://www.amazon.com/Pilgrimage-Plus-Paulo-Coelho-ebook/dp/B000JMKNZG/
There is a chapter simply titled "Death" and I can't recommend it highly enough. I'd definitely suggest reading the whole book so the chapter is in context. But in it he articulates the goal of becoming "friends" with your death. It sounds strange; but it is spot on. My future death is my friend because it is what reminds me that all the connections I have with loved ones RIGHT NOW are the point. All the beauty you can experience right NOW is all the beauty there is. As I mentioned in a post a few days ago, Sam has pointed out you can only be happy RIGHT NOW. You can never be happy "in the future."
What you are right now is a "miracle." And that miracle IS the Cosmos itself. It is both contained in a single life and transcends all life at the same time. And YOU ARE THAT. When your practice reveals your fundamental nature to you, you will see that the fundamental nature is universal. Individual lives are simply a part of the rhythm of the Cosmic dance. Therefore they should be cause for celebration and delight AS the rhythms that they are.
And the rhythm has two sides. You can't have life without death. You can't have existence without nonexistence. They go together. So there is nothing to fear.
There were no problems for you before you were born. Likewise there will be no problems for you after death. The Cosmic music and dance continue ever onward and, as Watts said: "...in knowing this, know you will never die."
All the best, my friend!