[CT-3189] [Bug] make dev is broken due to dependency conflict

[emmyoop]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

When installing dev dependencies you get a dependency conflict.

Expected Behavior

make dev installs everything without error

Steps To Reproduce

run make dev in a clean environemnt

Relevant log output

ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behavior is the source of the following dependency conflicts.
types-requests 2.31.0.8 requires urllib3>=2, but you have urllib3 1.26.17 which is incompatible.

### Environment

```markdown
- OS:
- Python:
- dbt:

Which database adapter are you using with dbt?

No response

Additional Context

We have urllib3 pinned to version 1 because requests depends on openssl (#7573)

For now, pin types-requests in dev-requirements.txt to get it working.

Future: Look into if/when we can unpin urllib3. Based on what I can find it's pin is related to dbt-snowflake so we will want to confirm with the adapters team too. #8790