What version of Ubuntu Noble are you using? Is it Raspberry Pi or amd64?
Can you run this command and show me the output?
find /usr/local/lib/plugins -type f
Also, run this and tell me what's in this file
cat /etc/systemd/system/snakeoil-rest.service
your problem is somehow in your environment your OS cannot find the plugins folder for that sqlite3 driver.