I never understood why that movie bombed. 1993 was a huge year for blockbuster movies, so I think it just got lost in the shuffle. Anyway, underrated flick.
It's a Hollywood story cliche. There are so many continuity problems in that movie, but if I recall, they were designed to be that way. Here's a decent write up about the whole preposterous nature of the movie: https://film.avclub.com/why-last-action-hero-failed-and-why-...