I have not seen the movie, even though I am a long-time Trek fan. I just have no interest any longer in the TNG crew. They have had their innings and obviously, they are all 20 years older than when the series began.
Their age is beginning to show compared to the younger actors appearing in other scifi shows. I think the main reason it did poorly at the box office is that it had little appeal for the general public as compared with the other fare available, such as Harry Potter and The Two Towers, to mention just two current releases.
I'm not sure how Enterprise is doing in the ratings but I suspect the long Trek saga is coming to a close.