I'm curious, I saw this ratcheting CVT on YT[1], and since I have no experience with mechanical engineering wasn't really able to judge how useful it was or whether it was practical, but it looked like the real deal?
There is some information about ratcheting CVTs (and CVTs in general) here [0], although the page looks a bit sketchy. From what I've seen, they are not very practical or widely used. Maybe there is a niche where their capabilities and drawbacks are a good fit but I have not come across it.
One thing to keep in mind is that these days it's not hard to beat (both on price and power/torque capabilities) sophisticated transmission mechanism (meaning - expensive and containing many fragile mechanical parts) by simply using a larger electric motor with variable speed control and fixed gearing. Torque output at low speeds (which would be the advantage of CVT) is going to be limited by mechanical design and weight constraints of the transmission mechanism.
It's useful and practical for some applications (despite what the author says in the video) and has been on sale for decades. But if you use ratchets for the ratcheting, the variability isn't continuous but discrete (as he explains in the followup video you'll presumably watch soon) and if you use sprag clutches or something, the drive is friction-based.
[1]: https://www.youtube.com/watch?v=G9-N-nIqc4g