For me it doesn't have anything to do with it being the Lions. The fans may have long memories of bad experiences, the players don't.
I don't care who you are in the NFL, winning 6 straight at any time isn't a cinch, less so with 2 of last 3 on the road and less than that with one in the cold in GB. Sure they may do it, but they may not. I'd put it at about 50/50 - like it would be for almost any mid-level or even upper tier NFL team asked to do the same.
If they get to 9-8 and end up at home, I'll still call it great season coming after 3 wins, and be excited to see what Holmes can do with another set of picks. If they get further, I'll still be rooting.