### Apache Airflow version

Other Airflow 2 version (please specify below)

### What happened

version 2.6.2

An error occurs when *.json is included in the parameters of BigQueryInsertJobOperator.
``` py
to_gcs_task = BigQueryInsertJobOperator(
        dag=dag,
        task_id='to_gcs',
        gcp_conn_id='xxxx',
        configuration={
            "extract": {
                 # The error occurred at this location.          
                "destinationUris": ['gs://xxx/yyy/*.json'],


                "sourceTable": {
                    "projectId": "abc",
                    "datasetId": "def",
                    "tableId": "ghi"
                },
                "destinationFormat": "NEWLINE_DELIMITED_JSON"
            }
        }
    )
```

error log 
```
jinja2.exceptions.TemplateNotFound: gs://xxx/yyy/*.json
```

### What you think should happen instead

According to the airflow.template.templater 
source : https://github.com/apache/airflow/blob/main/airflow/template/templater.py#L152
```py
      if isinstance(value, str):
            if any(value.endswith(ext) for ext in self.template_ext):  # A filepath.
                template = jinja_env.get_template(value)
            else:
                template = jinja_env.from_string(value)
            return self._render(template, context)
```

In the Jinja template source, if the value ends with .json or .sql, an attempt is made to read the resource file by calling jinja_env.get_template.

### How to reproduce

just call BigQueryInsertJobOperator with configuration what i added 

### Operating System

m2 mac

### Versions of Apache Airflow Providers

_No response_

### Deployment

Official Apache Airflow Helm Chart

### Deployment details

_No response_

### Anything else

_No response_

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

import pendulum
    first_execution_date = pendulum.datetime(2023, 1, 1)
    second_execution_date = pendulum.datetime(2023, 1, 2)
    third_execution_date = pendulum.datetime(2023, 1, 3)
    test_dag = DAG(dag_id="test_dag", start_date=first_execution_date)
    task = BaseOperator(task_id="test_task", dag=test_dag)
    common_dr_kwargs = {
        "dag_id": test_dag.dag_id,
        "run_type": DagRunType.MANUAL,
    }
    dr1 = DagRun(execution_date=first_execution_date, run_id="test_run_id_1", **common_dr_kwargs)
    ti_1 = TaskInstance(run_id=dr1.run_id, task=task, execution_date=first_execution_date)
    dr2 = DagRun(execution_date=second_execution_date, run_id="test_run_id_2", **common_dr_kwargs)
    ti_2 = TaskInstance(run_id=dr2.run_id, task=task, execution_date=second_execution_date)
    dr3 = DagRun(execution_date=third_execution_date, run_id="test_run_id_3", **common_dr_kwargs)
    ti_3 = TaskInstance(run_id=dr3.run_id, task=task, execution_date=third_execution_date)
    session.add_all([dr1, dr2, dr3, ti_1, ti_2, ti_3])
    session.commit()
    
    assert task.get_task_instances(session=session) == [ti_1, ti_2, ti_3]
    
    assert task.get_task_instances(session=session, start_date=second_execution_date) == [ti_2, ti_3]
    
    assert task.get_task_instances(session=session, end_date=second_execution_date) == [ti_1, ti_2]
    
    assert task.get_task_instances(
        session=session, start_date=second_execution_date, end_date=second_execution_date
    ) == [ti_2]