I like Stafford. I think he's a good QB.
But I don't like this trade much. It reeks of desperation. Goff wasn't the only problem for the Rams. People point out how effective Snead has been at finding talent later in the draft, but that luck doesn't always work. Look at Schneider with the Seahawks. It worked for a number of years, but now their drafts have descended closer to league average. The Rams desperately need draft capital to replace expensive veterans. They will likely lose Leonard Floyd, Troy Hill, Austin Blythe, Gerald Everrett, and a few other contributors.
Living in LA I watched enough Rams games to know that Stafford wouldn't have won them anymore playoff games.