Here are the pros and cons of WAL mode: https://sqlite.org/wal.html

For us, the biggest thing would be that it can't be used if the database is on a network drive relative to the host process.