The point is that it is much more intuitively understandable what happens when you fill whole columns with that formula.

In R1C1 notation it's obvious because the formula doesn't change. In normal notation the exact same thing happens under the hood, but the cell references you're seeing change.

Maybe, but named ranges make the whole thing somewhat moot. Your formulas should be human readable, ideally.