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.

• https://joyeecheung.github.io/blog/2024/03/18/require-esm-in-node-js/ is not official. It feels weird pointing folks to a third party platform. It also has a lot of details on historical context and decision-making that users who just want to learn the high level of the feature wouldn't want to have to read through. (it is a great blog post on its own though!)
• https://nodejs.org/api/modules.html#loading-ecmascript-modules-using-require is very technical and dives into the weeds of the module system.

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 nodejs/learn#34, intentionally with as similar an issue body as possible.

Start by reviewing the existing Node.js modules documentation, especially the “Loading ECMAScript modules using require” section, and compare it with the proposed high-level scope. Done means adding an official explainer or hub page covering what require(ESM) is, quick CommonJS examples, supported Node.js versions, FAQs such as TLA limitations, and links to related official resources.