I've written several papers in LyX, and I think it was a great way to get started with LaTeX. The main trouble I had with it was collaboration --- since it was a desktop app that not many (possibly none?) of my colleagues used, I couldn't really get anyone else to contribute, except by asking for them to provide text and then mostly manually inserting it back in to LyX.
In the end, they convinced me to just write LaTeX source into an EtherPad, which was fine once I got used to it. And Overleaf is basically just a refinement of this idea.
I hope that Overleaf's rich text mode also helps people climbs LaTeX's notoriously steep learning curve, and I hope it saves them from some of the collaboration problems that I had when I was doing the same. We have some evidence that it is helping, such as these high school students who somehow managed to write a 300 page report in LaTeX using Overleaf [1]. I think that's amazing!
[1] https://www.overleaf.com/blog/289-the-nano-ninjas-building-r...