Like all entertainment, being an author is generally not lucrative unless you are established as an author or some other kind of entertainer with name recognition. Once you are and can negotiate things like film rights or future book royalties then the sky is the limit.