My experience has been in compiling Hyperion.ng for the Vero4K. I’ve not used the RPi regularly for many years. As it is I have an RPi 3B+ up for testing other issues and can have a look.
I followed the apt instructions here.
Oddly, I do not have a hyperion.service file under /etc/systemd/system/, but a hyperiond@.service. So I do not know how you have been able to test using sudo systemctl status hyperion as you did?
It looks like they have an issue with their package dependencies. If you run:
sudo apt-get install libqt5sql5-sqlite
that will get rid of the SQLITE error.
However… although it has been compiled with
Avail Capt: dispmanx,v4l2,framebuffer,qt
only framebuffer is available. As tested in the webGUI Live Preview this works to show the console, but Kodi is not there. I expect previously that would have been the job of the dispmanx grabber. Not sure what they are planning to do to support the new video drivers.
EDIT:
This has already been asked about and Pi 4 Kodi 19 hyperion with internal grabber - #3 by jamieburchell suggests it will be an ongoing issue upstream. An external USB grabber may still be an option.