Hundreds of people in need of significant pain relief support are set to see waiting lists surge as a result of health service retirements and budget cutbacks.