No, Stafford has a long career ahead of him in the NFL. I know fans here and elsewhere troll him but I bet you if you asked GMs around the league which QB they would build their team around sans maybe Aaron Rodgers, Russell Wilson, Cam Newton and maybe one other QB, Stafford would be taken ahead of any other QB given his age, ability, leadership and arm.
He's already proven himself as a leader who can lead the lowly Lions to a playoff berth at 23 years old while also throwing for 5,000 yards, 41 TDs etc.
He is IMO the most gifted passer in the league in terms of arm strength, accuracy and leadership. I've said it before but I can't think of one game in his career where I've gone "Stafford lost that game for us." He is good for at least 4,000 yards at a 2:1 TD, INT ratio.
Even last year, while changing coordinators and a disastrous start to the season for the whole team, Stafford bounced back and finished the season under Jim Bob Cooter with 19 TDs and only 2 INTs.
The only thing I could see is if he had a season of throwing for over 25 INTs (which isn't happening) in which case a lot of Lions fans would probably want to move on.
And even then QBs are such a rare commodity that I don't think Bob Quinn would get rid of him. Our GM Quinn, has stated that Stafford is the Lions QB and talks of an extension are already underway.
He is the franchise QB the Lions have been waiting 50+ years for but it's taken time because he was drafted at 21 years old in 2009 and took over the worst team in NFL history.
Whether it's in Detroit or elsewhere Stafford will be playing in the NFL for a long time.
Drew Brees, Matthew Stafford have best chance at Peyton Manning's yardage record
There are other articles as well outlining how Stafford is the only QB in the NFL on pace to break records set by QBs like Peyton and Favre.
He really reminds me of Favre in the way he plays and how competitive he is.
So I guess to answer your question, Stafford is the truth, and the only make or break for him this season will be with hyperbolic Lions fans who think franchise QBs grow on trees but he would then go on to continue his great career for another franchise.
I personally think Stafford will be in the MVP discussion this year given how he finally has continuity with the coaching staff and the players around him.