Pink Floyd was never a band known for their massive family-friendly image, but Roger Waters knew when some genres crossed the line