This does not show that the lightning network doesn't work. It shows that lightning has less locked value than Ethereum's layer 2. Incentivize yield farming is likely the cause.
In terms of lightning being usable now, I've been using it for years with no real problems, both as a merchant and as a consumer.