Herniated discs don’t hurt locally. They press on nerves and cause pain and weakness in the places where those nerves go.
The only legitimate purpose of disc surgery is to fix well defined nerve problems when conservative treatment is unlikely to succeed. It is never appropriate for “back pain.”