[doc] Add Resource categories section to RESOURCES

Describe workload resources and supplementary resources.
Describe migration strategies for supplementary resources.