Not really.
Then again, it may depend on what you were expecting.
If U2 or anyone else was expecting a song like "Boots" to rip up the charts, then yeah, it tanked.
However, if you expected this to be an alternative hit, then you would have predicted well as the song is a huge alternative rock success.
In the U.S., GOBY has been #1 on Triple A (aldult alternative) for four consecutive weeks. It's #5 on the Modern Rock charts. If it weren't for the iPod commercial, I would say that "Vertigo" would have received the exact same type of success (even though it was more radio-friendly). The iPod commercial pushed the song into another level. It should be noted that big hits on alternative radio don't always cross-over to mainstream. "Sex on Fire" by KOL was a huge alternative hit, but didn't even make the Hot 100 on the U.S. Billboard charts (to the best of my knowledge).
GOYB, in contrast, became a Top 40 hit in the U.S. Yes, it's stay was short-lived as Billboard changes how they manage the Hot 100 on a near weekly basis (i.e., what were hits years ago might not be now). But that Top 40 ranking makes it a bigger hit than many U2 classics.
Still, there's no way that particular song was going to cross-over. While some may like "The Fly" more, it too wasn't a hit (only in the U.K., where there was a rumor of the CD single being short-lived "special"). So like "The Fly", GOYB got out some early word. It wasn't designed to be a monster cross-over track. That's the job of the second single in this case.
With that in mind, U2 do need to get out the second single fast. I recommend a second single release the same week as the album's release. This way radio can say "and here's the new one from U2, on their just released album that you can buy this week".
An edit of "Magnificent" is ideal. The two fast songs in a row approach doesn't usually work. Fans want to see a change in pace. Hence, "Magnificent" is a good choice. But it is too long for radio. These aren't the glory days of radio, where a "Hey Jude" or "American Pie" or "Free Bird" or any other ultra long track could be played in its entirety. Radio now is a bit like early rock radio - shorter songs are better.
After "Magnificent", I think "Stand Up" works well. There's no other song remotely like GOYB on the album, so fans who were a bit turned off by that song (and that wouldn't be many as mainstream radio never played it, so no one has heard it), may enjoy a more traditional rocking song like "Stand Up". "Crazy" may also work (although I feel it needs a bit of editing for radio).
But U2 should move fast. GOYB wasn't a flop, but it wasn't a huge hit that could keep interest in the album for months. So a second single is needed ASAP. Hopefully with this extra time (as the original goal was to release the album in November), U2 are ready to go with single #2 in a few weeks. If not, they should start work now.