Add delete_active_pod cleanup mode and unit tests for process_pod_deletion

https://github.com/apache/airflow/pull/59160