But what we know for certain is that Lightning Network is not widely used where it is expected to be used
It isn't widely used
yet. That doesn't mean it is somehow broken or dysfunctional. Lightning is pretty much still brand new in the grand scheme of things, and adoption takes time.
This is what counts in the end as Lightning Network is supposed to fix the innate problems which prevent Bitcoin from being used as a means of payment
It does. Lightning is still in beta, but can still be used now, and is instant and near feeless. It is working well. Adoption will come.