[Bug]: @storybook/addon-storyshots does not support es module exports

[khelif96]

Describe the bug

In #9576 @storybook/addon-storyshots was updated to allow importing storybook configs from a main.ts file. But it only supports CommonJS module exports using the module.exports format. It would be great if it could also support ES module exports using export default as that is what is recommended in the docs for a storybook config. https://storybook.js.org/docs/7.0/react/configure/overview
#9576 (comment)

To Reproduce

No response

System

System:
    OS: macOS 12.6.2
    CPU: (10) arm64 Apple M1 Max
  Binaries:
    Node: 19.0.1 - /opt/homebrew/bin/node
    Yarn: 1.22.19 - /opt/homebrew/bin/yarn
    npm: 8.19.2 - /opt/homebrew/bin/npm
  Browsers:
    Chrome: 109.0.5414.119
    Safari: 16.2
  npmPackages:
    @storybook/addon-actions: 7.0.0-beta.34 => 7.0.0-beta.34 
    @storybook/addon-essentials: 7.0.0-beta.34 => 7.0.0-beta.34 
    @storybook/addon-interactions: 7.0.0-beta.34 => 7.0.0-beta.34 
    @storybook/addon-links: 7.0.0-beta.34 => 7.0.0-beta.34 
    @storybook/addon-storyshots: 7.0.0-beta.34 => 7.0.0-beta.34 
    @storybook/react: 7.0.0-beta.34 => 7.0.0-beta.34 
    @storybook/react-vite: 7.0.0-beta.34 => 7.0.0-beta.34 
    @storybook/testing-library: 0.0.14-next.1 => 0.0.14-next.1

Additional context

No response

[jonniebigodes]

The Storyshots addon is officially deprecated and will be removed in a future release of Storybook. To help with the transition process, we've created a migration guide for the available options and common use cases.