### Apache Airflow version

2.7.1

### What happened

Hi team,

In the past you can use `AIRFLOW__CELERY__BROKER_URL_SECRET` as a way to retrieve the credentials from a `SecretBackend` at runtime. However, as of Airflow 2.7, this technique appears to be broken. I believe this related to the discussion [34030 - Celery configuration elements not shown to be fetched with _CMD pattern](https://github.com/apache/airflow/discussions/34030). The irony is the pattern works when using the `config get-value` command, but does not work when using the actual `airflow celery command`. I suspect this has something to do with when the wrapper calls `ProvidersManager().initialize_providers_configuration()`.

```cmd
unset AIRFLOW__CELERY__BROKER_URL
AIRFLOW__CELERY__BROKER_URL_SECRET=broker_url_east airflow config get-value celery broker_url
``` 
This correct prints the secret from the backend!
```
redis://:<long password>@<my url>:6379/1
```
However actually executing celery with the same methodolgy results in the default Redis
```cmd
AIRFLOW__CELERY__BROKER_URL_SECRET=broker_url_east airflow celery worker
```
Relevant output
```
- ** ---------- [config]
- ** ---------- .> app:         airflow.providers.celery.executors.celery_executor:0x7f4110be1e50
- ** ---------- .> transport:   redis://redis:6379/0
```
Notice the redis/redis and default port with no password.

### What you think should happen instead

I would expect the airflow celery command to be able to leverage the `_secret` API similar to the `config` command. 

### How to reproduce

You must use a secret back end to reproduce as described above. You can also do
```cmd
AIRFLOW__CELERY__BROKER_URL_CMD='/usr/bin/env bash -c "echo -n ZZZ"' airflow celery worker
```
And you will see the ZZZ is disregarded
```
- ** ---------- .> app:         airflow.providers.celery.executors.celery_executor:0x7f0506d49e20
- ** ---------- .> transport:   redis://redis:6379/0
```

It appears neither historical _CMD or _SECRET APIs work after the refactor to move celery to the providers.

### Operating System

ubuntu20.04

### Versions of Apache Airflow Providers

Relevant ones
apache-airflow-providers-celery          3.3.3
celery                                   5.3.4


### Deployment

Docker-Compose

### Deployment details

_No response_

### Anything else

I know this has something to do with when `ProvidersManager().initialize_providers_configuration()` is executed but I don't know the right place to put the fix.

### Are you willing to submit PR?

- [X] 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)

from airflow.stats import Stats
from airflow.utils.dag_parsing_context import _airflow_parsing_context_manager
from airflow.utils.log.logging_mixin import LoggingMixin
from airflow.utils.net import get_hostname
from airflow.utils.timeout import timeout
log = logging.getLogger(__name__)
if TYPE_CHECKING:
    from celery.result import AsyncResult
    from airflow.executors.base_executor import CommandType, EventBufferValueType
    from airflow.models.taskinstance import TaskInstanceKey
    TaskInstanceInCelery = Tuple[TaskInstanceKey, CommandType, Optional[str], Task]
OPERATION_TIMEOUT = conf.getfloat("celery", "operation_timeout")
CELERY_FETCH_ERR_MSG_HEADER = "Error fetching Celery task state"
if conf.has_option("celery", "celery_config_options"):
    celery_configuration = conf.getimport("celery", "celery_config_options")
else:
    celery_configuration = DEFAULT_CELERY_CONFIG
celery_app_name = conf.get("celery", "CELERY_APP_NAME")
if celery_app_name == "airflow.executors.celery_executor":
    warnings.warn(
        "The celery.CELERY_APP_NAME configuration uses deprecated package name: "
        "'airflow.executors.celery_executor'. "
        "Change it to `airflow.providers.celery.executors.celery_executor`, and "
        "update the `-app` flag in your Celery Health Checks "
        "to use `airflow.providers.celery.executors.celery_executor.app`.",
        RemovedInAirflow3Warning,
    )
app = Celery(celery_app_name, config_source=celery_configuration)
@celery_import_modules.connect
def on_celery_import_modules(*args, **kwargs):