The level of discomfort from acupuncture is minimal. It ranges from no pain at all to the type of pain you might feel from a mosquito. Very occasionally it will feel worse than that. Once the needles are in the patient feels a pleasant state of euphoria and often fall asleep.
Here is a video of a patient getting some acupuncture: