Does SUPERAntiSpyware Professional need to be running for the real-time protection to work?

Yes, SUPERAntiSpyware Professional must be running in the system tray (little brown "bug" by your clock).