Well sure, context is important. Your situation, or the band's, can have a profound affect on how you experience something like that.
But as a purely objective comparison (or as close to objective as I can get), I would say it's the worst opening "song" I've ever heard from them. I would liken it to them starting a concert with the opening riff of Zoo Station....but only if they stopped before the lyrics, and if Zoo Station wasn't even a song in their catalog. Calling it half-baked is being generous.
For all the struggle they seemed to go through in nailing down an opening number for the tour, I would think any number of tracks would have worked very well as an opener, and they could even have rotated them if they wanted to. Breathe was ok, but might have worked even better in a rotation. The title track would have worked too, as would GOYB or Magnificent. Or go the "classics" route with I Will Follow, or NYD/SBS. The number of possibilities make the choice to open with Stingray all the more confounding.