Kyler Murray's Cardinals had won seven consecutive games to open the season, but Arizona finally came unstuck against Aaron Rodgers and the high-flying Packers.
Rodgers (22-of-37 passing for 184 yards without an interception) threw two touchdown passes to Randall Cobb as the Packers held on to beat the Cardinals – playing for the first time without star defensive end JJ Watt – after Murray's stunning last-gasp interception.
Chase Edmonds' 11-yard run gave the Cardinals a first-quarter lead – the Arizona star had entered Week 8 with 397 rushing yards this season, the most by any player in the NFL without a rushing TD.
Rodgers and the Packers took control from that point as Jones' second-quarter TD run and Green Bay's superstar quarterback Rodgers' pass to Cobb in the third quarter put the visitors ahead 17-7.
James Conner did strike before the end of the third to close the gap to three points, though the Rodgers-Cobb combination struck again early in the fourth to make it 24-14 in the Packers' favour.
Conner's second rushing touchdown set up a thrilling finish but as the Cardinals attempted to rally to their eighth straight victory, Murray (22-of-33 passing for 274 yards, no TDs and two interceptions) threw an interception on second-and-goal with 12 seconds remaining – Rasul Douglas on hand to snatch the ball in the corner of the end zone.
Wide receiver Cobb has agreed a three-year, $27million deal with Houston that contains $18.75m in guarantees, according to NFL Network.
The move came after star wideout Hopkins was stunningly sent to the Cardinals in a package that saw running back David Johnson move in the other direction.
Houston also netted a second-round draft pick this year and a fourth-rounder next year, while sending away their 2020 fourth-round selection.
Four-time All-Pro Hopkins later tweeted to say the city of Houston will "forever be loved" and stated his new goal was to bring a championship to Arizona.
As well as adding Cobb and Johnson, the Texans have re-signed cornerback Bradley Roby, tight end Darren Fells, quarterback AJ McCarron and kicker Ka'imi Fairbairn.
Cobb, 29, spent last season with the Dallas Cowboys and caught 55 passes for 828 yards before hitting free agency.
The slot receiver had spent the first eight years of his career with the Green Bay Packers, striking up an impressive connection with QB Aaron Rodgers.
The short-handed Packers ended the Cardinals' perfect start to the season while extending their winning streak to seven games following a 24-21 victory in the NFL on Thursday.
With 12 seconds remaining, Douglas was on hand to thwart the home team as he snatched the ball in the corner of the end zone from Kyler Murray's pass.
Douglas, who was previously with the Cardinals' practice squad, was only in action in the absence of Jaire Alexander and Kevin King.
"This is why I love this squad," Rodgers told Fox.
"The guy who made the pick was with them for four weeks. He was on the street, we brought him in, he's starting for us.
"He's a great dude and he's really meshed well with our team, and to come up with a play like that with 15 seconds left is incredible."
Rodgers, without wide receivers Davante Adams and Allen Lazard, was 22-of-37 passing for 184 yards as Matt LaFleur's men got the job done in gritty fashion in Arizona.
"This is a scrappy team," Rodgers said. "This is a tough, physical, gritty team.
"I'm so proud of our guys. I'm so proud of our line. I'm having so much fun with these guys.
"We ran the ball well, we knew we could. It was tough in the passing game at times, but [Randall] Cobb came up with a couple big touchdown catches."
