HDF5 is much better suited for a lot of scientific data sets. How would you store multidimensional data in sqlite? Not everything is a table or matrix.
HDF5 also allows you to pick compression filters that are especially suited for the data you have.
If you are looking to replace a CSV file, then sqlite is obviously a pragmatic solution.