Whether a material is superconductive or not is a property of that material, not of what we connect it to (although I believe that real superconductors have limits on current density before they lose their superconductive properties).
A piece of copper doesn't become a superconductor when connected between hot and neutral of a mains circuit. It will still have a finite conductivity of a little bit less than $6\times 10^7\ {\rm S/m}$ at ordinary operating temperatures, changing depending on the wire's temperature, how it was annealed and worked in drawing, etc.
When your book says the wire provides a "zero resistance path", what they really mean is a path with much lower resistance than the usual paths through the circuit. If the usual load on the circuit is 100 ohms, this might mean a 1 ohm path. If the usual load on the circuit is 1 ohm, it might mean a 1 milliohm path.
In general in circuit theory when we talk about "zero resistance" wires we really mean a resistance much lower than any of the elements that we've included in our model, not an actual superconductor. This makes it much easier to analyze circuits, while introducing errors that can easily be much smaller than the errors from our imperfect knowledge of the characteristics of the other elements we might use to physically build our circuit.