### Description

Currently, KubernetesPodOperator fetches logs using
```
             self.pod_manager.fetch_container_logs(
                    pod=self.pod,
                    container_name=self.BASE_CONTAINER_NAME,
                    follow=True,
                )
```
and so only shows log from the main container in a pod. It would be very useful/helpful to have the possibility to fetch logs for all the containers in a pod.


### Use case/motivation

Making the cause of failed KubernetesPodOperator tasks a lot more visible.

### Related issues

_No response_

### Are you willing to submit a PR?

- [ ] Yes I am willing to submit a PR!

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)

"""Note: this test requires that you have a namespace ``mem-example`` in your cluster."""
        fixture = sys.path[0] + "/tests/kubernetes/basic_pod.yaml"
        k = KubernetesPodOperator(
            task_id=str(uuid4()),
            in_cluster=False,
            labels=self.labels,
            pod_template_file=fixture,
            do_xcom_push=True,
        )
        context = create_context(k)
        result = k.execute(context)
        assert result is not None
        assert result == {"hello": "world"}
    @pytest.mark.parametrize(
        "env_vars",
        [
            param([k8s.V1EnvVar(name="env_name", value="value")], id="current"),
            param({"env_name": "value"}, id="backcompat"),  
        ],
    )
    def test_pod_template_file_with_overrides_system(self, env_vars, test_label, mock_get_connection):