chore: update major deps

[bluwy]

Description

Update major deps, those locked in renovate, and some minor versions

Additional context

Notes:

• Update deps that are ESM only as Jest is removed and Vite exports ESM by default
• Update cac, seems to be fine as the CLI is now written in ESM
• Update execa, needed to handle breaking name changes
• Didn't update TypeScript, may be safer done separately
• Didn't update major versions in playground, may be worth checking separately e.g. react 18

---

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.