Star Wars Episode XVI - Paths of Chaos
Palpatine is well known as bringing peace to the galaxy, for a time. The Empire kept order through the galactic civilizations, with three death stars at its command to keep everyone in check. This peace ended with the rise of the fulminar and the Alliance of Free Worlds.
After Mavick was destroyed and the new ancients of the force sided with the AOFW, the Empire lost much of its support and funding. Palpatine held onto his power for awhile, but eventually he, Anakin Skywalker, and the remaining Empire forces faded into obscurity.
It’s unsure if Palpatine is still alive hundreds of years later, but their are rumors of Sith lords able to extend their lives beyond the norm. Small factions still believe Palpatine and his Empire was the right way and will return in full force, but they are few and far between.