ESM/ES Module project support

[psychobolt]

Is your feature request related to a problem? Please describe
Storybook currently fails to require main.mjs or main.js if projects are configured to use { "type": "modules" }

ES Modules. E.g. ERR! Error [ERR_REQUIRE_ESM]: require() of ES Module <some_project_path>/.storybook/main.js not supported.

Describe the solution you'd like
Storybook can build and run without any problems for projects with ESM formated config.

Describe alternatives you've considered
Just sticking with commonJS... #16181

Are you able to assist to bring the feature to reality?
No, I am hoping someone can chime in. For now I am using the workaround. Just creating this feature request for future work tracking...

[psychobolt]

Closing since its being worked on and tracking release for 7: https://storybook.js.org/blog/storybook-6-2/

[CarlosBalladares]

same on 6.5