He will always be a hero for what he did in his first term. To be a hero again in his second term he will have to give us something to cheer about - i.e. a decent promotion push (from league 1) next season.
Getting us relegated and then promoted back to league 1 would not make him a hero.