Awesome thank you again Otto,
The fix was a combination of
How to unlock locked metadata fields en masse
and
How to rebuild collections on Reddit (pconwell on reddit walked me through it with baby steps, the info was 2 years old, but still working)