What overhead does that add in practice? Like a second or so to scan a few GB of tarball? Does that matter?
Zstandard at a high compression level gives a good tradeoff of decompression speed vs underlying physical throughput, be it network or spindle.
Even so, yes, the sequential nature of tar is not great for this reason.
Squashfs files, which can be used on Linux and Mac (using fuse for OS X), are a very good alternative for archIves, though without some of the features described in the linked article.
if it already resides locally on a seekable media , there's litle drawback
Think of it like a linked list.
*: As opposed to a few large files.