The Super Administrator gives you the same sort of power that you get with Root in Linux, meaning there's no User Account Control (UAC) prompts and the Command Prompt or PowerShell are run with elevated privileges. Activating Super Administrator can be useful for power users, advanced diagnostics, or if you got locked out of your main account.
There was always just one administrator account from Windows XP back, but that changed in Windows Vista, 7, 8, and 10 with what many call the hidden Super Administrator account.