Honestly, the success rate probably varies by acupuncturist. Some folks are pretty good with these types of issue and some folks aren't. Addictive behaviors are also complicated by patient choices. If a person isn't ready to quit smoking, there's no needle that is going to make them ready to quit smoking.
Specific to acupuncture and Chinese medicine in the US is the further complicating factor that not all acupuncture providers have actually attended and graduated from an accredited school of Chinese medicine. Some 'acupuncturists' will have 100 hours or less of training in acupuncture and Chinese medicine, this makes it hard to estimate their actual skill level in the modality - some will be pretty good, others won't be good at all.
If you're looking to try acupuncture to help quit smoking (or to help someone you know quit smoking), you're looking for someone with an NCCAOM national board certification (a Dipl Ac or Dipl OM credential) along with a state issued L.Ac. or R.Ac. credential. Without both those things, it's kind of like an adult going to a pediatrician to deal with a brain tumor - yes a pediatrician is an MD, but their training doesn't cover that particular issue in the adult age group.
NCCAOM.org has a 'Find a Practitioner' lookup which you can use to find someone with the proper credentials in your area.