There are other techniques for automatic flagging of similar files, like PhotoDNA's [1] enormous database - which I believe PornHub are already using.
For the purpose here, robust hashing seems to be the relevant term:
https://www.netclean.com/netclean-report-2019/robust-hashing...
This is equivalent to image recognition. It works ok, but has lots of false positives and false negatives.
As you note, it isn't particularly reliable, but it does actually tend to work fairly well against the loss of video compression. However, it doesn't tend to work well when the video is recut, with time added or removed. There is some research trying to combine approaches for finding important keyframes (ML-powered thumbnail searching) with perceptual hashing [0], which is looking promising, but it's still fairly unreliable.