I actually wasted a few $$ of disposable income on buying the DVD of this film. Best Buy was running a special during the first week of the DVD sales where you'd get a model of the Astin Martin car (or whatever the hot car from the film was) that is supposed to be valued at $9.99 for free.
The model car is probably worth all of $4.99, and the DVD that was on sale for $16.99 is probably worth about the same.
It's hard for me to put it into reasons someone else might understand, but I just wasn't that happy with the film. It ran long, way too long really, and the last chapter or two of the DVD were filled with what seemed to be a "make good" in the area of effects and action. A "make good" that was probably needed because of the preceeding 20 minutes of wasted film that seemed to do nothing more than show off some landscape.
Other parts of the film also seemed to lack the tension that should be there in any Bond film, and certainly there was a lack of gadgetary until well into the film.
I'd hope that the series gets better, no matter who plays the lead, though I share your thoughts that terminating Brosnan's run as the star was unnecessary. He was going fine in the role and as noted, if there was anything wrong before, it's the same thing that is wrong now -- bad stories and poor scripts.