Add `delete_active_pod` cleanup option and corresponding unit tests (#59160)

https://github.com/apache/airflow/commit/2887405a25d672a7ef454f4d0d1eee5c82e32067