People were overly enthusiastic about it intially, but soon realized almost no one wants to use a slower, riskier, and now more expensive payment option. Bitcoin is good for merchants but terrible for buyers.
Bitcoin lightning could change this, instant transactions with almost no fees, but it's still in early days.
The Phoenix wallet[0] is actually quite a nice LN solution. When I tried it out it gave me similar feelings of excitement as when I first got into Bitcoin.
Reading about the Lightning Network gives me a headache in general, but Phoenix manages to hide all the tech stuff. I think my old parents would be able to use it.
And it solves one LN problem of having to have bitcoin for opening a payment channel, you can simply install the wallet and start receiving bitcoin.
Bitcoin lightning could change this, instant transactions with almost no fees, but it's still in early days.