You reincarnate, like everyone else. There is no afterlife, Sovngarde was really just a skooma-induced delusion to put your mind into the right mental frame you would need to be in to fight Alduin, who was both feeding on the ghosts of people who weren't able to reincarnate and defecating them back into the cycle.