Every "Zelda" game has been named after the Princess, and not the main character. Twilight's a pretty good word...
It's a strong adjective and noun, what more could you ask for in a title?
I'd rather play "Twilight Princess" than "Grand Theft Auto"
But that has nothing to do with the names.