Litestream is overkill for this; "VACUUM foo INTO foo.db;" is all you need.

https://www.sqlite.org/lang_vacuum.html