So I guess I'm just wondering if it'll be able to substitute coding for most people's needs.
It is. That's the whole point.
Ppl used to coding might feel lost at first, because most of the code is done with the mouse through the ACE table instead of actualy writing down hundreds of code lines with your keyboard.
But in the end, you can do as much with C2 (and I'd dare to even say more in the perspective of ppl not used to coding) than with a plain notepad and JS for example.
Also, once you start to get into complex expressions, it gets close to real coding imo, and coding-used users shouldn't feel as lost as in front of a blank even sheet.