It is normal. But it goes something like this: The Incredible Tale of the Tiny Red Dog.

Words like of, the, are, is etc. don’t get a capital.

Sauce: MA in English Language, and voluntary journalist.