I'm not sure what to make of the Rams right now on offense. Jackson has shown to be a good rb this year and put up good numbers at times so holding him to 6 yards...holding any NFL team to 6 yards in a game is something to at least be optimistic about.
As far as Warner being consistent, he's done really well since coming back from injury and I think #12 among starters in passer rating right now. St. Louis, on paper, wasn't much of a test but emotionally it was a huge game for him. But, putting up good numbers against a bad defense isn't something to be overly praised for.
The Detroit game was something that makes me feel optimistic about the passing game. Detroit is still in the top 10 in pass defense and held Bledsoe and the Cowboys to just over 100 yards passing yesterday (after the Cardinals put up 350+ last week). Add to that, Jacksonville struggling against Tennessee, the Cardinals' chances are better than if you just look at each team's record.