This doesn't seem rogue. Your organization was most likely underwent a scheduled upgrade to Business storage. In this case it also seems that you have entitlements from what are possibly different organizations (or Admin Consoles), which have provide entitlements to different products. In your case it's likely that one Admin Console is used for Creative Cloud and another one for Workfront. In such a scenario, because it's difficult to automatically segregate assets to figure out which assets belong where, the assets remain behind in the Personal profile. And so that you have the ability to access them and move them, you're provided a complimentary subscription to your Personal profile.
To migrate the assets, you can try the following:
- Sign in with your personal profile and export the Library. And sign out.
- Sign in with your Business profile. Choose the org/profile in which your colleagues are
- Import the Library.
- I'd recommend using Teams Libraries for this use case. It's one of the features of this Storage upgrade and provides organizational storage. Teams Libraries belong to the Org rather than a user. So even if a user leaves or is unavailable, assets remain with the team.
5. Other assets will need to be moved manually to the desired Profile. See Transfer assets.
Not optimal, I agree. But this seems to be the fastest way forward. Let us know if this helps.