Does Egg Become Another Mad King? The Prophecy In A Knight Of The Seven Kingdoms Explained

Egg's prophecy in A Knight of the Seven Kingdoms doesn't bode well for his future, but does he really become so despised as a king of Westeros?