I wouldn't rule out Sony's chance of messing things up yet!
In all seriousness though, my prediction is that all this fury will fade into begrudging acceptance, which will change to general acceptance (though we'll all still complain because we're on the internet and that's what it's for).
It's not been long since initial reveal, some people wanted to be angry, some people are angry because they've been riled up and I'm betting a whole lot more people were just bored by the reveals and are fairly indifferent.
I don't think the console will flop. There will be titles that people will want to play despite the platform, there will be friends that get the console who people will want to play with, there will be parents and grandparents that buy the console as gifts, there will be roomates and housemates that get the console, there will be a price difference that may go in xbones favour, there will be new features and updates that may improve the ugly features announced today, etc, etc.
In all honesty, while I'm not supporting no backwards compatibility, installing games, always online, stalker kinect, no used games, etc if the xbone gets a seriously awesome exclusive title (better than any of the PS4 titles) then I could probably overlook these things. I'd still complain about them, but I'd deal with it. I already deal with two of those on PC and one of those things in previous console generations. That's half the list of shit things (..so far).
If this generation is a massive fail for Microsoft, it will not be because of what we've heard today about the xbone.