doc: improve net docs

Clarify destroy behaviour and refer back to streams docs for further and more accurate description of behavior details.

Refs: https://github.com/nodejs/node/issues/31916

Checklist

• make -j4 test (UNIX), or vcbuild test (Windows) passes
• tests and/or benchmarks are included
• documentation is changed or added
• commit message follows commit guidelines