Yeah, the movie was a flop, despite it being one of Carpenter's best films and being all round excellent.
It's gained a lot wider recognition in the years since though.
ETA: if a sequel ever was made, although i'd prefer it wasn't, JC should definitely not direct it. He has lost his touch a long time ago. We'd just get another Ghosts of Mars.