Do you think we will ever se him again ? maybe in a future TES as a secondary boss or something ?

No.

Do you know the prophecy behind him coming to Tamriel this time?
That's not likely to repeat itself.

Maybe we'll see him hanging around in some plane in Oblivion, nursing a grudge. It would be fun to do so in order to have the opportunity to troll the curmudgeony old wyrm.

It was said that Alduin was destroyed and it is up to Akatosh to bring him back.