compat: Dynamic import from CJS module fails

[bartlomieju]

Reported by @Jack-Works in #12577 (comment)

// node_modules/pure-cjs/index.js
async function run() {
    const result = await import('pure-esm')
}
run()

// index.js
require('pure-cjs')

deno run --compat --unstable --allow-read --no-check ./index.js
error: Uncaught (in promise) TypeError: Relative import path "pure-esm" not prefixed with / or ./ or ../ from "file:///dev/deno-compat-test/node_modules/pure-cjs/index.js"
    const result = await import('pure-esm')
                   ^

This is the same problem as in #12628 - if we're executing module via require then the module graph is not constructed and module resolution falls back to the "regular" ESM resolution (ie. NodeEsmResolver is not being used).

Related to #12684