Yes, under the hood (although the distinction between file-based and content-based doesn't seem to be all the important from the conceptual model point of view--you generally access the content of blobs in Git via file-based interfaces).

The point is he's talking about how the systems appear conceptually. Conceptually the model that best describes Subversion from a user point of view is a file system that stores a snapshot of all prior states of the filesystem.