It's not only about size but about speed column stores that store compressed data and process data in blocks using SIMD perform significantly faster on many query types.
SQL Server sort of does this with traditional indices and columnstore indices. Indices are derived data structures that represent a view of the original dataset, so in theory it shouldn't matter if the original data is stored in rows or columns.