Cupid is the Roman name for the Greek god Eros.

Eros Ancient Greek: Ἔρως, lit.  ‘Love, Desire’) is the Greek god of love and sex.

Eros is where the word that erotic comes from.

I think the joke works on that level, since things clearly went awry