fix: use createRequire() for require.resolve()

[ehmicky]

Part of #749

When migrating to pure ES modules, require stops being available a global variable. However, we use require.resolve() in this repository. This PR uses createRequire() so require.resolve() remains available even after we migrate to pure ES modules.

---

For us to review and ship your PR efficiently, please perform the following steps:

• Open a bug/issue before writing your code
  🧑‍💻. This ensures we can discuss the changes and get feedback from everyone that should be involved. If you`re
  fixing a typo or something that`s on fire 🔥 (e.g. incident related), you can skip this step.
• Read the contribution guidelines 📖. This ensures your code follows our style guide and
  passes our tests.
• Update or add tests (if any source code was changed or added) 🧪
• Update or add documentation (if features were changed or added) 📝
• Make sure the status checks below are successful ✅