I've never been embarassed to say I mystery shop, but most people I have spoken to don't know what it is, so I have to explain what it is. Then they respond saying that is a cool thing! I've worked in retail before I started having kids, so I knew mystery shoppers were out there.
If anything, I often tell people what I end up getting for free or severely discounted due to mystery shopping.