I think women like New Moon because the way Bella feels through most of movie is something most women have felt at one time in their life. I know I personally saw the movie and I knew what that pain was. But she finds a way to keep moving forward. (And it doesn't hurt that both Jacob and Edward are both candy for the eye.)