What do you think it will be?

If we're running with dramatic irony? Yeti, back to human altogether, or yet another victim of the Starscribe Treatment™

I'd say mare but Discord already went with that so...

7066506
What is the starscribe treatment?

Well knowing Discord... Ranma-like treatment? ;D

Personally I see three possibilities

1.) He loses his horn

2.) He becomes human again

3.) This being the possibly the final story, Page falls asleep and can only interact with others in the dream world. He eventually wakes up in the future, taller, and finding that Sunset is gone.

Thestal, as fluttershy is one of the only ones left

7066526
Turned into a mare. All of Starscribe's human male protagonists end up as one.

7066530
Tempest is no worth it. Plus he was given a choice to let it go on or end it and reverse his gift and the price it cost

7066530

2.) He becomes human again

Or, more chaotically, turn him into what Navarone currently is running around as....

Page DID say that it mustn't piss off Fluttershy.
Luna, On The Other Hoof....

7066506
Starscribe treatment?

7073363
see
7066569