I don't know from personal experiance, but I would asume it's like getting the top of your ear pierced which I have, and yes, it hurt.
Rook piercings hurt along the same lines as an orbital, tragus, industrial/scafold etc. It's a cartiledge piercing (where it tends to be thick), so it usually 'hurts'. Everyone has their own pain-threshold, but just think of it like this. It's 10 seconds of discomfort, for a lifetime of one badass piercing! Also, cartiledge piercings tend to 'burn' more than 'sting', if that helps any. Ever been whacked in the ear with a snowball? Yeah, that's what I'm talking about .