Have been having the same problem. Thanks to this thread, I realized that my prefs folder in Dropbox wasn't set to 'make available offline'. Once I changed that and downloaded it locally, everything is good.
Yes--that didn't work either.
(Problem is only on my work computer. Contacts search works fine at home. When I enabled Spotlight metadata at work, that didn't fix the problem there and it made Home stop working.)
Went through all the troubleshooting steps for Contacts not showing up in Alfred.
Alfred isn't listed in the apps that have requested accesss in this step...
Check that Alfred is listed in macOS's Security & Privacy > Privacy > Contact and that the box next to Alfred is checked
None of the other troubleshooting steps have fixed the problem.