I see that according to the biblical scriptures, all people were created for the purpose of being in a relationship of love, unity, and oneness with God the Creator forever.
There's the rub. Not everyone believes in the Bible. I do not believe in it or that there is one creator God who rules the universe, or that I was born to obey and serve him. As for my own beliefs as to where I'll wind up after death, that is up for grabs. And that is because Heathens are not concerned with an afterlife, but rather with living this life as best we can. Heathenry is usually referred to as world-accepting, not world-rejecting. We do not believe in sin or the need for salvation, given that there is nothing to be saved from.
That said, many (most?) Heathens believe we go to a place where we're re-united with our families, friends and ancestors in a not unpleasant realm, not unlike this life but without the hardships. No, we don't go to Valhalla. That is what we pejoratively call a Brosatrú or Vikingtrú belief. At the very best, we'd go to the hall and realm of our personal deity. Afaik, not even that is attested to anywhere. It could very well be UPG ("unsubstantiated personal gnosis" - something you believe but can't prove) or MUS ("made up [stuff]", but "stuff is not the word usually used).