The Lemonheads were one of those bands that the industry really, really tried to make famous (same thing with Urge Overkill), and it didn’t happen because they weren’t that good. Juliana Hatfield, and her band The Blake Babies, were best known because she dated him for a while (see footnote). As for Natalie Merchant, I’m pretty sure she still does some songwriting and recording, but she’s had at least one child so that no doubt keeps her busy.
Footnote: The comic strip “Frazz” used to have a peripheral off-panel celebrity character named Juliana Evandando.
p.s. Before the Lemonheads got a major-label contract, my brother interviewed them when he was a college DJ. He described them as “wet noodles”.
Another one that comes to mind is Bruce Hornsby. I saw him when he was at his commercial peak, in the late 1980s, and it was a great show. I do know that he later toured with the Grateful Dead, and also put out an album of atonal “music” at one point, which was definitely a contrast with what he’d done in the past.