Sqlite isn’t quite one person, but it is a very small team and is extremely widely used. https://www.sqlite.org/mostdeployed.html

What you’re describing sounds like burnout to me. Stepping away from coding could be a good step in recovering. New offer certainly sounds worth trying, I hope it goes well.

Restic supports symlinks: https://restic.readthedocs.io/en/latest/040_backup.html#backing-up-special-items-and-metadata.