Investigate adding support for ts-node/esm

[tgriesser]

Current behavior

In 10.0 using package.json with "type": "module" with .ts will not work out of the box without esbuild installed.

Desired behavior

Cypress should use the ts-node/esm builder to support loading .ts from esmodules. https://github.com/TypeStrong/ts-node#commonjs-vs-native-ecmascript-modules

Test code to reproduce

cd system-tests
yarn test config_modules_spec

config-cjs-and-esm/config-with-ts-module fails but it should pass

Cypress Version

10.0

Other

Related to #21574

[lmiller1990]

This will come for the ride with #22074 most likely! The core problem is the same: need better es module support. I am working on it, so I will assign this to myself.

[lmiller1990]

WIP PR: #22118.