A little bit... but Detroit wasn't doing anything offensively in the second half. Our drives here:
9 plays, 4:36, 44yards, FG
6 plays, 2:40, 13yards, Punt
3 plays, 0:52, 6 yards, Punt
It's not unreasonable at all to think that their defense could hold and get the ball back to Stafford. 4th and 14 isn't impossible, but it also isn't easy and missing means you give the Lions a relatively short field and a relatively good chance of at least getting a FG, meaning you need a TD to win.
Punt and force the Lions to a 3 and out with that much time left? There's a good chance you get into FG range to win it. I don't think it was necessarily a bad call to punt. Obviously it turned out bad, but I wouldn't call it a terrible decision at all.