Spotlight doesn't display contacts

Reboot your Mac into Safe Boot mode and try the same Spotlight search. Then, reboot normally, and repeat the same search to see if there is any change. Safe boot mode will take longer as there are several System housekeeping tasks being accomplished.

I just powered up a MacBook Air running macOS 10.15.7 and all security updates and got the same result as you for a Spotlight search of Contacts. All you can do after you find and click to select the contact name is to press cmd+R to open the Contacts application to that specific card information.

What happens when you enter:

kind:contact name:john

And if you see a list of John first names under the Spotlight Contact category, select the pertinent one and the scrollable contact information should be shown in the adjacent Spotlight panel.

Of course, the preceding assumes that you have selected the Contacts category in System Preferences > Spotlight > Search Results panel.

It's what comes after you reboot normally, whether it fixes the issue or not. In my test here, after my recommendation to you to try Safe Boot, it got the same results as you with just that UUID string. That means it is a Catalina issue and not we end users.