Wildcard syntax works better with explicit select filters

### 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/reference/node-selection/methods

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

For all the variety of wildcard syntax folks may want to use, they may need to explicitly add the `file:` or `fqn:` selectors for their selector specification.

Here are some examples: https://github.com/dbt-labs/dbt-core/issues/11333#issuecomment-2766798270

Maybe add a stand-alone section on this page for wildcard selection syntax examples?

### Additional information

Opened this issue per https://github.com/dbt-labs/dbt-core/issues/11333#issuecomment-2772397677