Can I retrieve my photos from Time Machine backup?

Trying to restore an iPhoto Library from an old backup drive.

Tried option-click-launching Photos in macOS Monterey v12.7.6 to select Library, but error reports Library cannot be read.

Lots of family photos with notes and metadata stored 14 years ago when old iMac died. I was meticulous in keeping backups on HDD and TimeMachine. Any way to retrieve them?

[Re-Titled by Moderator]