Just because most popular operating systems have libraries, doesn't yet mean it is portable.
Can I click on it and open it in Excel?
If not then it is not portable for me and for a lot of other people.
The main reason I use CSV is to produce reports that I can either open myself or send to other people so that they can click on it and open themselves and immediately start hacking away.
Excel is still corporate lingua franca and until this changes CSV is not going to retire.
CSV means for me that I can send it to anybody and everybody will know how to use it.
Try sending SQLite binary to people you work with, to your accountant, to your wife. Then share your experience.
I find files where the exact type of whitespace used is meaningful to be a sick joke.
Not all editors make it easy for you to use a tab character.
If only there was some other solution that would not require you to use a character that a lot of editors refuse to insert or even try to convert to spaces...
It also runs on all kinds of embedded devices in addition to personal computers and servers.
https://en.wikipedia.org/wiki/SQLite#Operating_systems