I love the film. The script is apalling, yes, and the way James Cameron characterized the real-life passengers and crew was horrible...but I love Kate Winslet, and the special effects still hold up very well. It was amazing to watch in the cinema, I saw it four times.
It's a nice movie to watch if you switch off your brain and don't take it seriously. If nothing else, it's an exceptionally beautiful looking film, with the sets, costumes, etc. The "I'm flying" scene is so gorgeous to look at, however cheesy it is.