Upgrade pnpm to 9.1.4

[vraravam]

Pre-flight Checklist

Please ensure you've completed all of the following.

• [x] I have read the Contributing Guidelines for this project.
• [x] I agree to follow the Code of Conduct that this project adheres to.

Description of Change

Upgrade pnpm to 9.1.4

Motivation and Context

From @Alphrag : A few things that I have seen that are good in it: it uses node-gyp v10.x which means rebuilding some dependencies won't fail (like sqlite3 if we wish at one point to upgrade it again to the latest version, but is not recommended atm), and allows shorter paths of included node-modules for windows which could fix a problem for some users

Screenshots

Checklist

• [x] My pull request is properly named
• [x] The changes respect the code style of the project (pnpm prepare-code)
• [x] pnpm test passes
• [x] I tested/previewed my changes locally

Release Notes

[vraravam]

Will need to wait for the next nightly so that other fixes can be released as a nightly. After which, we need to merge this PR, and finally upgrade the recipes submodule with the latest, and then test this PR

[Alphrag]

All good on Windows!