I agree: the Library (or database) has become messed up
No available formats says that the Record points to a folder that appears empty (calibre does not know of the book format contents, if it there)
In addition to the cloud drive issue:
Messing beneath the skirts: Renaming, moving, (compressing?) all will cause

Only use the Calibre UI to manipulate books.
1) search for metadata.db
2) Are there author folders in the same place? (No= not the correct Library or '
all gone'

)
3) are there book formats,metadata.OPF, cover.jpg inside? (Yes= the DB is messed, but possibly recoverable)