If sequential and random reads are mostly the same on SSDs, does that make the distinction between columnar and row-based databases/data storage less important?
Nope, unless your columns are all several kB wide. If you force the hardware to perform a multi-kB read for each 64-bit value you need, you're still going to waste a lot of potential performance.