Follow-up: remove checked-in chart dependencies in favor of a more sustainable solution

Summary

Context: !2599 (merged)

To mitigate repository availability issues, we checked in the chart dependencies to the codebase.

Going forward, we should consider reverting this in favor of a more sustainable solution.

Acceptance criteria

• Add back the dependency update, but for the dependencies update pipeline
• Document the process of manually updating and checking in the chart bundles when updating the requirements.lock
• Discuss alternative approaches of mirroring