Not all DAGs have DAG_DEFAULT_ARGS applied

[AetherUnbound]

Description

When running the Elasticsearch health check DAG recently, I noticed that it didn't have the DAG_DEFAULT_ARGS applied (because a failure wasn't automatically alerted into Slack when it occurred). In addition to adding the default args to the following DAGs, we should also add a check or test which ensures that DAGs have an on_failure_callback set up (or some default args set up).

[nav] In [10]: from airflow.models import DagBag
          ...: d = DagBag()
          ...: for dag_id, dag in d.dags.items():
          ...:     on_failure_callback = dag.default_args.get('on_failure_callback')
          ...:     if on_failure_callback is None:
          ...:         print(dag_id)
[2024-02-16T20:42:53.422+0000] {dagbag.py:538} INFO - Filling up the DagBag from /opt/airflow/catalog/dags
rotate_db_snapshots
production_elasticsearch_cluster_healthcheck
staging_elasticsearch_cluster_healthcheck

Additional context