Lumbar decompression surgery has a high success rate of nearly 90%, with most patients experiencing significant pain relief and improved mobility post-operation.