CSV based export/import would involve writing to disk, sending over network then reading back from file. Select is just one copy over network, no intermediate CSV.
You can stream CSV without writing it to a disk.
What would be the point in that?
COPY is way faster than INSERT, at least in PG.
Fwiw you'd lose type information. Parquet / arrow are much more appropriate here