If the Bible is true, all our desires for relationships are nothing but earthly version of an ultimate desire for relationship with God. In heaven, this apparent conflict will be reconciled.
If the Bible is true, all things of this world will go away. The only way this can be said to be devoid of reason is if we refuse to see it other than through the lenses of the world.
It doesn’t seem to make sense only if we expect things to be as we would have them.
The only way it wouldn’t come close to resembling reason, truth, or justice in any rational sense is if we were the authors of reality.
But we’re not, we’re merely participants. In some cases, this is probably the most difficult truth to accept—the greatest barrier.
If you're convinced that the Bible must be true no matter what, then you've made a presupposition that makes history and reason secondary.
I will say that I don't respect beliefs simply because people have them, but I can empathize with the philosophical gymnastics you've put yourself through in order to accommodate a religious text, even convincing yourself that your family is irrelevant in the long run and are of no consequence in the afterlife.