Yes, Tropy will only be able to find photos if the necessary change to the path of the missing photo can be deduced, in some way, from the photo path you consolidated. In practice, if you moved all your photos together there will be a common sub-path that needs to be changed in all the paths so Tropy would normally be able to detect them easily. However, since you moved the photos to a different drive, I’m guessing that you’re using Windows and so that paths have a new drive letter. Unfortunately, this means that there is no valid relative path from the old to the new location (Tropy tries to compute this relative path and apply it to other missing photos) and for this reason the auto-consolidation fails.
The best way to move the photos to an external drive on Windows is to first move the project file to the same folder as the photos, open the project, and change the preferences to use paths relative to the project file, close the project and move both project file and photos to the new drive. But it’s too late for that now (you could move the photos back temporarily, but with 13k files this takes a long time) so I think the best solution is to fix the paths manually in your project file.
The project file is a SQLite database, you can open it with the sqlite3 command-line tool; on Windows I’ve also recommended DB Browser in the past. Before you go ahead and inspect your database file, please make a backup copy, in case something goes wrong!
In the database, the paths to your photos are stored under
photos.path. So for example, to list all your photo paths you could use the command
select path from photos order by path;
To change a common prefix in all your paths instantly, you can use a command like
update photos set path = replace(path, 'C:\\OLD PATH', 'E:\\NEW PATH');
If you tell me from where to where you moved your photos I can post the exact command you can use.