Update helm chart prometheus to v29.40.3

This MR contains the following updates:

Package	Update	Change
prometheus (source)	minor	29.31.1 → 29.40.3

Notes for Reviewer

• For security reasons, our Renovate fork cannot trigger canonical chart pipelines
  • ⚠️ Reviewer needs to initiate new MR pipeline, subsequently triggering chart pipeline from it. ⚠️
• The assignee is responsible for fixing any issues raised during review. Please leave feedback as comments and hold off on approving until those issues are resolved.

---

Configuration

📅 Schedule: (UTC)

• Branch creation
  • At any time (no schedule defined)
• Automerge
  • At any time (no schedule defined)

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

♻️ Rebasing: Never, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this MR and you won't be reminded about this update again.

---

• If you want to rebase/retry this MR, check this box

---

This MR has been generated by Mend Renovate CLI.