(Even Roualt here)

I see fossil head contains WKT definitions in with TOWGS84[] terms in them. Those were useful in a GDAL < 3 & PROJ < 6 world, but they are now a nuisance with GDAL 3 and PROJ >= 6 as can been seen in

I'd suggest that the future of Spatialite no longer contains them since it will likely be more likely deployed with GDAL 3 and PROJ >= 6