the acupuncturist placed needles all over my wrist and it hurt like h*ll. he told me it wouldn't hurt, but it did. keep in mind though that this was back in the mid 90s when i wasn't yet diagnosed with cts. at the time, my neurologist was simply treating me for wrist pain and nothing else. i also had 2 cortizone shots that were unsuccessful.
Acupuncture needles generally speaking shouldn't hurt. The reasons they may hurt is because the acupuncturist does not put in the needles with qi (energy), the muscles are tense and contract around the needle, or because the meridian is severely out of balance. Each pain is pretty distinct. In my experience the muscle tension pain is by far the most painful. It sounds to me like it was painful for you because your acupuncturist places the needs at the site of pain--which acupuncturists are advised to avoid. My acupuncturist massages the point and manipulates qi (energy) with her fingers to relax the muscle and to somewhat balance out the meridian before inserting the needle into a point she thinks may be particularly painful. You might consider asking your acupuncturist to do this if you plan on receiving acupuncture in the future. You could also request that they stay away from your actual wrists.