Go to System Preferences → Apple ID (at the top right) → iCloud (tab on the left) → Try to uncheck “Optimize Mac Storage”.
This might force your files to stay downloaded locally. (It should, but I don’t really know if iCloud respects the setting.) If it’s checked, it may be offloading to the cloud, and appearing missing to Alfred/Obsidian.