Clarify interaction of project <> package dependencies for same resources/namespace

### Contributions

- [X] I have read the contribution docs, and understand what's expected of me.

### Link to the page on docs.getdbt.com requiring updates

https://docs.getdbt.com/docs/collaborate/govern/project-dependencies#comparison

### What part(s) of the page would you like to see updated?

- Retitle section to something like "Comparing "project" and "package" dependencies
- Clarify that, in all cases where the same namespace / resource is installed via both "project" and "package" dependencies, the "package" node is preferred. This is true even in cases where the "package" nodes are explicitly disabled (by setting `enabled: false` in the root `dbt_project.yml`)

### Additional information

Context:
- https://github.com/dbt-labs/dbt-core/issues/10224
- https://github.com/dbt-labs/dbt-core/pull/10223#discussion_r1617274876