That's a good point and something I'd not considered.

I'd say the main benefit is that it's tailored only to SQLite's features.

You don't have to tweak a UI tailored for remote connections to work with local files. You don't need to have extra sections dedicated to user management or stored procedures which are inactive. I guess I'm saying that in this case less is more!