JADES: Probing interstellar medium conditions at $z\sim5.5-9.5$ with ultra-deep JWST/NIRSpec spectroscopy