Is "The Wall of the Faithless" still a thing in Forgotten Worlds? If so then that's a pretty good reason for *everybody* to have a deity, not just Paladins.
We don't know. WoTC removed mention of it some time into 5e but didn't mention if it was retconned away, it's still there but not something WoTC want's to promote as a feature of the afterlife, or if something actually happened to it. Ironic considering they stopped Obsidian from putting an option into NWN MoTB to destroy the wall. Hopefully something that's addressed in BG3 in some capacity, since Myrkul is back, and the Wall was IIRC the only thing keeping him around in any capacity since his other contingency didn't pan out. There was a particular cosmic house of cards that the Wall was supporting that prevented the Fugue Plane from turning into an absolute mess.
Anyways, even without the Wall, you'd likely just be resigned to the same fate as the false, if another god didn't try to 'claim' you as under their domain (something they can do, apparently, with Kelemvor's permission) or you got snatched by demons while wandering the plane.