It answers flaws that their competitors haven't been able to satisfy... either they do a superior camera but sacrifice the keyboard and/or NAM 3G... or both while answering items that Nokia themselves were themselves absent on before (the huge touchscreen - I was amazed at how long it took until ANYONE challenged the iPhone on their screen) and full qwerty together with their high end camera.
Mostly, it doesn't matter if it's S60 or Android or iPhone. The precise problem with iPhone is that you get their one set of hardware with nothing else. If it was Android instead of S60 on N97, I wouldn't really care as long as they're giving me the big touchscreen, the sliding Qwerty, 5mp+ cam, and 3G.
Not unless I was looking for a MacBook Air.

Just because Nokia has the hubris to call this thing a "computer" doesn't mean I believe them (or care about their marketing angle).
Will it browse the Internet as good as the iPhone? All indications are: yes.
Will it also have a superior camera to anything else available with US 3G? Yes.
Will it have QWERTY to facilitate those who don't like touchscreen-only for text messaging and emails: Yes.
Ultimately, that's what matters most to me and anything else is gravy.
Will it beat the iPhone on the game front? Probably not, but that aspect isn't one bit important to me. I myself usually restrict my gaming on my PS3 or 360 in front of my 60" big screen.
If Ovi-store tanks, I probably wouldn't weep too hard, but then I mostly scorn and sneer the foolish iPhone Nazis at my work for their oooh and ahh over the latest crap app. I expect most of the stuff on Ovi isn't going to have much appeal to me. I might experiment with the oddball theme here and there, but imagine that will get old after a few months and I'll stop. It mostly just needs to perform good as a phone for text/SMS/email and the oddball browsing if I'm bored at work or stuck at the DMV or jury duty or something.
What else will matter? I'm not a big social networking guy (only on LinkedIn so far), but am actually considering starting Facebook just because of this. If it sucks and leads to out of memory errors, I'd probably get rid of the widget. If I can browse the occassional game on ESPN or hit up the radio station or if it will let me leave my iPod classic in the car and replace my need to carry a point and shoot, N97 will have been wildly successful on the convergence front whereas before nothing had a good enough camera or storage to make it even semi feasable. I have alot of music (and a 160GB iPod classic), so don't expect anything to fully succeed but so far this is the closest thing that looks like it has a hope to succeed across the board.
Or I'll ditch it in a year for Idou.