Update project to Yarn 4

What does this MR do and why?

To avoid problems we seem to run into a lot, let's update to Yarn v4 up from the v1 series.

See: !4555 (comment 1747594842).

Merge request acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this merge request.