Superior hypogastric nerve block is a minimally invasive procedure where local anesthetic is injected near the superior hypogastric plexus to alleviate chronic pelvic pain by blocking the transmission of pain signals from the pelvic region to the brain.