Seconded. Plus, Jeanne Tripplehorn was smokin’. Hmmm. According to Wiki, Jack Black is in it; I don’t remember him. As to its profitability:
With a budget of $175 million, the film grossed a mere $88 million at the U.S. box office, which seemed to make it the all time box office bomb. Adjusted for inflation and expressed in 2006 dollars (USD), the budget for the movie was $231.6 million, and grossed $116.8 million at the U.S. box office. The film, however, did much better overseas, with $176 million at the foreign box office (for a total of $264 million), and good VHS and later DVD sales.
I will say that I think the best part of the movie is the first minute or so, when the Universal logo fades away and the camera zooms in over the Earth, and you gradually see all of the landmasses disappear as the oceans rise. That was a cool effect.