Bigquery Cost Estimation wouldn't use new profile target

### Expected behavior

bigquery cost estimation should use the default profile target we set on profiles.yml even after we change it

### Actual behavior

I tried bigquery cost estimation using my dev profile target, and when i change my default target to prod (or vice versa),
bigquery cost estimation will still calculate using my dev target.

this also happens to compile dbt preview and execute dbt sql feature

### Steps To Reproduce

use bigquery cost estimation feature / compile dbt sql / execute dbt sql,
change default profile target
use the feature again

### Log output/Screenshots

_No response_

### Operating System

Ubuntu 22.04.5 LTS

### dbt version

1.8.6

### dbt Adapter

dbt-bigquery

### dbt Power User version

0.39.20

### Are you willing to submit PR?

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