Jared is a good QB. The problem is he needs a supporting cast, i.e. decent OL play and a strong run game. On the flip side, constantly playing from behind will make any QB look bad. The problem with the Lions is their crap defense who can't stop anyone. Give Jared a decent OL, run game, and good defense, and he can be that 2018 type of QB once again.
With two first round picks in the next two years, Holmes can build that defense and OL quickly. I think if Campbell can be patient with Goff they have a QB they can build around. Once they get Decker off of IR they can move Sewell back to RT than it will give them Decker and Sewell at OTs and Ragnow at C which is a very good start on building that OL.
Detroit has 4 picks in the first 3 rounds (2 first, 1 second and third). Holmes knows how to draft having been with the Rams since 2003 and named director of college scouting in 2013. So Brad has seen both how to draft well and how not to draft well that's why I expect the Lions to be a completely different team in 2023.
Look how Snead turned things around in LA. IMO Holmes could very well do the same in Detroit. Building a team starts in the FO that's why teams like the Jets will be doormats for a long time. They had a good QB and didn't even know it. They don't understand that even the best QB needs a team around him to be successful. Look no farther than Stafford to see the truth in that.
When the Rams beat the Bucs it will be a statement win. It will put the entire NFL on notice that there is a big dog in the house. Remember, the Rams are built much like the Bucs who chewed up KC and spit them out in the Super Bowl. It's why teams like KC, Baltimore, and AZ will tank if they lose their QB. But the Rams can keep rolling with either Wolford or Perkins. The QB only needs to play well and not lose the game for this team to stay in the hunt.