Can someone tell me about egg retrieval?

I was recently talking to someone about it and now I’m a little freaked out. Is it as awful as it sounds?