For the most part, Lampard was a good player who pretty much only ever played with other good players his whole career (which adds an advantage), then did a middling job before managing a Chelsea team of good players, doing a middling job there.
Whoever thought he'd be able to do a job with a team that struggled under Champions League winning managers is clearly insane tbh.
Lampard would have made sense if the academy was bursting with the next Stones/Barkley/Rooney/Rodwell types that needed blooding, in a similar way that Arteta has done at Arsenal, but not when you're already sinking into a relegation battle. I don't buy that there isn't a manager who could do a decent job with this lot, but you need specific types of managers who are suited to this kind of squad. Unfortunately, they'd be unfashionable ones, like your Moyes/Allardyce/Bruce types - win ugly, get the points, reset a little. Can't pass your way out of the bottom 4.