Red matter is no more ridiculous than the Genesis Device.
Or the Nexus? Or Ilia, Decker,and V'Ger coming together in a giant sparkly orgasm?
Look, a lot of the "science" in Trek is more metaphorical than anything else. Like the transporter splitting Kirk into two different aspects of his personality. Or V'Ger as a case study of intellect without emotion. Or Garth's shape-changing ability reflecting his unstable personality.
Is it it hard science? Of course not. But it works on a symbolic, emotional level . . . like a lot of Ray Bradbury's stuff.
(He says channeling his inner English instructor.)