I interpreted it as the problem being that the technology may end up unsupported. I mean you can also keep using pgbackrest now. It's not like the code is gone.

Well, yes, I meant that you don't need any 'special' tooling for Sqlite, whereas you do for pg.