### Apache Airflow version

Other Airflow 2 version (please specify below)

### What happened

Using Apache Airflow 2.4.3 and apache airflow google provider 8.4 (also tried with 10.1.0).
We have a query that in production should run for a long time, so we wanted to make the BigQueryInsertJobOperator deferrable.
Making the operator deferrable runs the job, but the UI and triggerer process don't seem to be notified that the operator has finished.
I have validated that the query is actually run as the data appears in the table, but the operator gets stuck in a deferred state.

### What you think should happen instead

After the big query job is finished, the operator should exit it's deferred state.

### How to reproduce

Skeleton of the code used

```
with DAG(
    dag_id="some_dag_id",
    schedule="@daily",  
    catchup=False,
    start_date=pendulum.datetime(2023, 5, 8),
):
    extract_data = BigQueryInsertJobOperator(
        task_id="extract_data",
        impersonation_chain=GCP_ASTRO_TEAM_SA.get()
        params={"dst_table": _DST_TABLE, "lookback_days": _LOOKBACK_DAYS},
        configuration={
            "query": {
                "query": "{% include 'sql/sql_file.sql' %}",
                "useLegacySql": False,
            }
        },
        outlets=DATASET,
        execution_timeout=timedelta(hours=2, minutes=30),
        deferrable=True,
    )
```

### Operating System

Mac OS Ventura 13.3.1

### Versions of Apache Airflow Providers

apache airflow google provider 8.4 (also tried with 10.1.0).

### Deployment

Official Apache Airflow Helm Chart

### Deployment details

We're using astro and on local the Airflow environment is started using `astro dev start`. The issue appears when running the DAG locally.
An entire other issue (may be unrelated) appears on Sandbox deployment.

### Anything else

Every time the operator is marked as deferrable.
I noticed this a few days ago (week started with Monday May 22nd 2023). 

### Are you willing to submit 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)

The missing values are treated as nulls. If false, records with missing
            trailing columns are treated as bad records, and if there are too many bad
            records, an invalid error is returned in the job result. Only applicable when
            source_format is CSV.
        :param encoding: The character encoding of the data.
            .. seealso::
                https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#externalDataConfiguration.csvOptions.encoding
        :param schema_update_options: Allows the schema of the destination
            table to be updated as a side effect of the load job.
        :param src_fmt_configs: configure optional fields specific to the source format
        :param time_partitioning: configure optional time partitioning fields i.e.
            partition by field, type and  expiration as per API specifications.
        :param cluster_fields: Request that the result of this load be stored sorted
            by one or more columns. BigQuery supports clustering for both partitioned and
            non-partitioned tables. The order of columns given determines the sort order.
        :param encryption_configuration: [Optional] Custom encryption configuration (e.g., Cloud KMS keys).
            .. code-block:: python
                encryption_configuration = {
                    "kmsKeyName": "projects/testp/locations/us/keyRings/test-kr/cryptoKeys/test-key",
                }
        :param labels: A dictionary containing labels for the BiqQuery table.
        :param description: A string containing the description for the BigQuery table.
        """
        warnings.warn(
            "This method is deprecated. Please use `BigQueryHook.insert_job` method.",
            AirflowProviderDeprecationWarning,
        )
        if not self.project_id:
            raise ValueError("The project_id should be set")
        #