feat(ssr)!: remove dedupe and mode support for CJS

[bluwy]

Description

reverts #3951

Remove hookNodeResolve and the ssrRequireHook plugin so there isn't a chance for Vite's custom node resolver to interfere in cases we don't want to. Followup to #10593

Additional context

I've hit this issue again at withastro/astro#5459, it would be nice to remove this in Vite 4.

We don't have tests that cover this feature.

---

What is the purpose of this pull request?

• Bug fix
• New Feature
• Documentation update
• Other

Before submitting the PR, please make sure you do the following

• Read the Contributing Guidelines.
• Read the Pull Request Guidelines and follow the Commit Convention.
• Check that there isn't already a PR that solves the problem the same way to avoid creating a duplicate.
• Provide a description in this PR that addresses what the PR is solving, or reference the issue that it solves (e.g. fixes #123).
• Ideally, include relevant tests that fail without this PR but pass with it.

[benmccann]

hurray! this would fix #10352, so I've linked that issue to the PR

[patak-dev]

And this is only for CJS. If there are folks that need this feature, we could also say that they can use Vite 3. I agree that this is a lot of added complexity for what we are getting at this point. cc @aleclarson, I think we should move forward and in the case, we found a real use case that can't stay in Vite 3, we can check what are our options (we can even revert this PR later, but at least we should try to move forward).