That's just low hanging fruit, the easiest and cheapest way to produce some solar power. But even if fully utilized, that is not going to come anywhere close to meeting most households' needs.
Any time you're exporting to the grid, you're losing out - the rates are never good. Check out the OP's graph. His setup is oversized by about 2x. He's exporting to the grid for most of the day, which is hardly useful, then pulling from the grid after 6pm - the worst of both worlds. Downsizing the solar setup 2x and investing that into batteries would be much better.
It's not a surprise that your bill is rising if people consume less during the day because they install balcony solar, but don't meaningfully change their peak consumption, and therefore, don't meaningfully reduce the grid investment required.
At least the blog's author has a battery setup which meaningfully moves their peak draw.