JK Rowling is richer than the Queen (for real!) but she is absolutely the exception and most authors will never make enough to live on, even if they are lucky enough to be published.
From personal experience, I know one children's author who has sold 10,000 books but has still not received any...