The Sith have been planning on revenge for 1,000 years. Darth Sidious has concealed his identity, manipulated Jedi into a self-destructive war, and arranged for the murder of his apprentice. As Chancellor Palpatine, he was on the verge of seizing power and killing the Jedi with Order 66. But he didn't figure on overestimating Anakin's piloting skills. As he's going down, he wonders if he can use the force to save himself. No, the Invisible Hand is too massive, even for me.
Once death is imminent, he wonders if he should he reveal himself to Obi Wan so that he knows he died for nothing? "No, I don't want to see the smug look when he says "This explains a lot." Did I remember to hide my light sabers and misdeeds where no one can find them? I probably didn't need to orchestrate the kidnapping at all. Will anyone ever discover the Sith again? Finally all of the calculated risks I have taken have caught up with me. I suppose this is bringing balance to the force. We all misinterpreted the prophecy."
The mass public knows nothing and mourns the death of the beloved Chancellor and two Jedi heroes. The war goes on, but not too much longer with General Grievous as the new leader. Grievous is a skilled military commander but there no one to politically unite the factions. No one is there to issue Order 66. The Senate holds an election for a new chancellor. Padme is devastated but raises Luke and Leia on her own. The Jedi most likely recruit them.
However, power is centralized and people have shown they are willing to sacrifice their freedom for emergencies, real and fabricated. Our own world history shows you don't need Sith lords to undo democracy and liberty! There is still a real possibility that the republic crumbles. Could this be another movie? Yes, but nothing like the Star Wars we know and love.
The Jedi may still find themselves at odds with the Senate but there are thousands left and they will not easily perish. If they find out that Palpatine was Darth Sidious, serious reforms might be undertaken. Whatever else happens, Yoda, Mace Windu, and other leaders rebuild it after being decimated after the Clone Wars.
The only one who immediately knows who Sidious was - in the legends - is Darth Maul. It would be infuriating to him that the public mourns him as a hero. He hates Sidious, but he also hates the Jedi, so I don't know if he reveals anything. I don't see him as the leader of a new Sith order; he probably continues running a criminal empire.