Better explain OVERRIDE option

[robertmaynard]

Description

Better explain that the rapids_cpm_init(OVERRIDE option, by bringing more details in from the rapids_cpm_package_override.

Checklist

• [x] I am familiar with the Contributing Guidelines.
• [x] The documentation is up to date with these changes.

[robertmaynard]

/merge