### 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)

pod = None
        remote_pod = None
        try:
            pod = self.hook.get_pod(
                event["name"],
                event["namespace"],
            )
            
            
            remote_pod = pod
            if event["status"] in ("error", "failed", "timeout"):
                
                if self.get_logs:
                    self.write_logs(pod)
                raise AirflowException(event["message"])
            elif event["status"] == "success":
                ti = context["ti"]
                ti.xcom_push(key="pod_name", value=pod.metadata.name)
                ti.xcom_push(key="pod_namespace", value=pod.metadata.namespace)
                
                if self.get_logs:
                    self.write_logs(pod)