Aside from X-2 and now 7, each Final Fantasy was a planets last stand against an overly destructive force. If the threat wasn't eliminated it would be it FINAL days. And since its not real, it is FANTASY. Thus FINAL FANTASY.
Actually, Final Fantasy I was intended to be Squaresoft's last game, hence the "Final" but because the game was so popular they made more, or something.