How soon this tech will find its way into cameras is a good question.
AI is notoriously processor-intensive - translating to a heavy burden on the battery. Even my M1 Max can't do it anywhere near real-time, which is basically the prereq for even considering putting this kind of silicon into a camera.
But yes, the results can be near-magic compared to conventional methods.