Scientists have a sense of humor like everyone else -and sometimes they use it to for names that will used for ever. However, there are cases where there's a perfectly logical explanation for a name, but the result is still a junior high school joke. Take SEX, for example.
For the record, SEX is a compound used primarily in ore mining; because it is attracted to metal of various types (copper, nickel, lead, gold, etc), SEX is added to slurries to extract bits of ore from water. Technically speaking, one could say that SEX is a tool used by gold diggers.
Oh yeah, it stands for sodium ethyl xanthate. That's just one of ten minerals with funny names, explained at Geeks Are Sexy. Link