Sex pistols, as I am sure you know, is a band. The name is slang for a penis (or I guess technically more than one penis). You can't substitute "sexy" because that would be modifying the word "pistols". So to say "sex pistol" is to refer to a penis, but if you said "sexy pistol", you would be saying that you thought a gun (pistol is another name for a gun) was sexy.