If it is the plug on the counsel, most good computer repair shops will fix/repair these kinds of faults.
If you’re wanting to try and fix it yourself then check out the ifixit SNES repair manual where it will show you how to open up your SNES. After opening the SNES look at the solder joints that are for the AC supply and resolder if the AC plug is ok or remove and replace with a suitable replacement.