Migrate MemorySink fully to v2

There's already a MemorySinkV2, but its use is controlled by a flag. We need to remove the V1 sink and always use it.