Pina suggests checking the resistance across CR5. Anything higher than 3.6K Ohm may be a sign the flyback transformer needs to be replaced. It may also be the barrel rectifier at CR5. Is the floppy error code actually "XXXX" or random numbers? An 0F error code can be indicative of a poor voltage regulation, which it definitely seems you have. The first thing you should do before you do ANYTHING else is make sure all of your voltages are properly supplied.
Also, what is this Whoop-Whoop-Whoop sound? I can't say I've ever heard the power supply make such a noise. Is it a repetitive noise from the drive itself like constantly ejecting, or is it actually a musical sound from the PSU? Could you also describe it as "Flup, Flup, Flup"? CR21 on the PSU could be a culprit in that case.
I'm confused about which Superdrive you are using. Perhaps a model number? You say G3, but also 575. I have personally used a 575 Superdrive on my 128K.