They should have let TNG go and let DS9 or Voyager take over the movie reigns or just not made a movie at all. I know that's a hard pill to swallow for TNG fans, but TNG had it's time in the sun and it was well past the time to pass the movie torch as well...
Ummm, the TV ratings for TNG in first-run syndication were stupendous (as were TOS in prime time syndicated repeat), and that in-built audience, plus the general public, was attracted to see TOS and TNG movies on the big screen.
Audiences for DS9 and VOY and ENT (the last two on a fledgling TV network that wasn't even broadcasting to some parts of the USA) got smaller and smaller and smaller
. None of those series were viable properties for the big screen.