[Bug] dbt-snowflake installs pre-release versions of dbt-core

### Is this a new bug?

- [x] I believe this is a new bug
- [x] I have searched the existing issues, and I could not find an existing issue for this bug

### Which packages are affected?

- [ ] dbt-adapters
- [ ] dbt-tests-adapter
- [ ] dbt-athena
- [ ] dbt-athena-community
- [ ] dbt-bigquery
- [ ] dbt-postgres
- [ ] dbt-redshift
- [x] dbt-snowflake
- [ ] dbt-spark

### Current Behavior

dbt-snowflake has `dbt-core>=1.10.0rc0` in its dependencies
This means it will take any pre-release version of dbt-core.
As of writing the max pre-release version is 1.11.0-b2 which is not compatible with any dbt packages so far and everything breaks.

### Expected Behavior

dependency should be `dbt-core>=1.10.0` meaning only release versions >= 1.10.0

### Steps To Reproduce

1. create a new virtual environment
2. install dbt-snowflake==1.10.2
3. run `dbt --version`

### Relevant log output

```shell

```

### Environment

```markdown
- OS: any
- Python: any
- dbt-adapters: dbt-snowflake
- :
```

### Additional Context

_No response_