For those who were wondering, it is available more broadly [0] than it was when the article was written (2020).. 75+%, almost 85% on tracked desktop.
Containment spec, which `content-visibility` is built on top of, reaches around 95%, (98% mobile) [1].