Surface catalogue pipeline queues retaining messages

[kenoir]

Following an incident where we missed messages accumulating on the catalogue pipeline main queues, we should surface this somewhere to avoid the issue happening again.

See https://www.notion.so/wellcometrust/Digital-Platform-sprint-plan-16-30-October-2024-1146687658a1808b9872d125d883b45a

• [x] https://github.com/wellcomecollection/platform-infrastructure/pull/450
• [x] https://github.com/wellcomecollection/terraform-aws-sqs/pull/14
• [x] https://github.com/wellcomecollection/catalogue-pipeline/pull/2741