We were not allowed to use any other pools, despite paying a $25 per night 'Resort Fee.' We stayed in the Great Cedar section - 1 of 4 towers in the huge complex - and the pool was closed.
But for a total of $925, including taxes and fees, I would expect a lot more to be included in the experience than just a decent hotel room. If you like to gamble all day every day, you'll have a great time. Foxwoods has nearly nothing to do but gamble.