I think it depends a lot on the type and level of pain, along with your overall physical condition. With the physicality of a dancer, I'd think it would definitely be worth your time to do the trial and see how it works out for you.
I was essentially bedridden for over 2 years before I had my trial/permanent implant, so I had and still have a LOT of physical rehab to conquer. When I started my rehab program, I couldn't walk for more than 5 minutes at .5mph on my treadmill. Now I'm exercising 2-3 hours a day, 5-6 days a week. At this point, I'd say I've eliminated about 85% of what I was taking prior to my implant, in spite of the huge increase in my physical activities. I expect to eliminate the remainder of the medication over the next 3-6 months, as I continue to get physically stronger.
My doctor said from the very beginning that it was a perfectly reasonable goal to eliminate all of my pain medications. If I had to stay where I am now, I'd still be beyond thrilled with the situation. It was well worth eliminating even half the medication, because it was such a huge improvement in my quality of life. The most important thing you have to keep in mind is that it's not an instantaneous cure. Like any other treatment, it requires time and patience to get exactly where you want to be.