Create an explainer / hub page for unflagged require(ESM) support

Enter your suggestions in details:

The new unflagged require(ESM) support in Node.js is very exciting. It's starting to let a lot of tools move to ESM without feat of leaving dependents behind. 🚀

But, there isn't one single high-level, official resource I can find that users can be pointed to to understand the unflagged support.

Proposal: can the Node.js site have a page added dedicated to the unflagged require(ESM) support? I'd imagine it could contain:

  1. What "require(ESM)" is
  2. Quick examples of requiring an ES module from a CJS file
  3. What versions of Node.js have it
    • Edit: ^20.19.0 || >=22.12.0 seems to be the common support target post-18.x
  4. Quick FAQs such as TLA being unsupported
  5. Links to learn more on the official Node.js website

Sibling issue to #7440, intentionally with as similar an issue body as possible.