Here's one meta-analysis of RCTs showing benefit for pain in fibromyalgia patients: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC6365227/

That's in comparison to a sham acupuncture placebo. And the placebo effect is already pretty powerful. Even in the "no benefit" studies, that's usually in comparison to a sham acupuncture placebo that has a real effect compared to waiting. In terms of pain treatment, I'd say even a safe non-addictive placebo treatment is pretty good, better than getting hooked on opioids at least.

I wouldn't get acupuncture hoping for a cure to cancer. But it's not exactly a stretch to think that manipulating nerves with needles will help with pain.