He was an incarnation of Akatosh and possibly a Shezarrine. Or the other way around. If you read the last of the http://www.imperial-library.info/content/song-pelinal, it sounds as if he is ascending to the realm of the gods and most likely being (re)absorbed into Akatosh. So instead of going to Sovngarde, he goes to his aligned Aedra after death. Although you must remember that Pelinal was probably a time-travelling lunatic and also may have been several people. Possibly one of his more Nordic variants
is in Sovngarde, but we don't meet him.