How many CSVs are generated, edited, or viewed by Notepad.exe and how many by Excel (or Google Sheets)?
I would posit the vast majority of CSVs are generated through some kind of program where you go to File > Export or File > Save As…. In which case doing selecting a drop down with the option for File Format to be TSV or DSV (with the corresponding file extension) would solve a lot of problems. (Or at least if CSVs from Excel were RFC 4810 compliant by default.)
There is still room between a text editor and a full-blown spreadsheet program. New DSV editors could emerge when the DSV format gains popularity.
CSV is equivalent to Voyager I, the chances of catching up with that kind of head start are extremely low.
DSV seems like worst of both worlds. Not really structured, AND also not really viewable/editable by lowest common denominator tooling.
Yes, but that is because those characters are not meant to be entered directly. DSV values should either be created by a dedicated DSV editor or they should be constructed by a software library. You would rather use a paint program to create an image instead of writing the image's bytes in a text editor.