And it's already in use. In the geospatial world we have geopackage, basically a replacement for the still ubiquitous shapefile. It's build on the idea of the earlier spatialite extension for sqlite. Then, shortly after the introduction of geopackage, esri followed suit and released their 'mobile geodatabase', also based on sqlite.

It works great as storage for geometries and attributes and at the same time you have the full power of sqlite for all kinds of analysis.