Besides Norman losing to the heroes and the Dark Reign ending, I think the way he shlould lose in the publics eyes is through bad PR. Norman has gotten where he is through the use of good PR. I don't want Norman to just revert to the Goblin, and I also dont want Norman rotting in jail. Norman has developed so much, that it would be a waste to just put him back where he was during Marvel Knights Spider-Man. Which was, that it was publicly known that Norman was the Green Goblin and he was rotting in jail.
I want Norman to lose the PR battle and be forced to resign from be director of HAMMER. It would be a blow to the reputation that he has built up since his rise to success. Not only would it be a blow to his reputation, but it would also be a blow to his psyche. I don't want the Goblin to fully come out, I want the Goblin t0 come out every once in a while. I would prefer if Norman kept his "Iron Patriot" persona or some kind of persona that was still "Iron-mannish". Maybe with Normans fall from power, he could give the suit a paint job. Either way,I want Norman to still be somewhat "successful".
If the Goblin comes out, I would like for it to be out of the publics eyes. When Norman chooses to become the Goblin, he should do things in deep secret. Also if the Goblin were to be seen in the public, Norman can always deny it was him. The president himself "saw" the Green Goblin die, and he also saw that Norman was the one to do the deed. So Norman has deniability.
Whether HAMMER stays in place, I don't know.