> Using SQLite for a network service when the app runs on the same machine as the SQLite file is perfectly fine

If preventing data loss is important for your app then this would be more hassle than using a networked db because now you have to replicate SQLite across a network to another machine.