I’d suggest finding out what’s happened.
Select one offline clip. Match frame to that clip in a bin.
Ensure source file and path are enabled as column headings.
Then look at that location for that clip.
Why isn’t it where MC expects it to be?
You can’t consolidate or transcode offline clips.
An AAF to resolve will still need you to drag all the source media to the media pool and you can only AAF sequences.
And the Avid attic only holds past copies of bins. It has no media.
My guess is your bad drive repair has lost media.