I don’t know a woman who wants a cockroach as a pet.
Most actually hate cockroaches, no doubt this joke must have caused a great scare.
Of course each joke has its degree of discomfort, some can even be pleasant.
Other jokes can get very awkward and unpleasant.
When you play a prank, remember to tell someone you trust very well and know that you will still be friends after the prank.