I think you are confusing "gods" in lowe-case, with God with capital letter. In High Fantasy, a cosmological higher force of good will not let evil triumph. That is based on the Christian God. The gods from the novels are not Gods in the way modern theology and philosophy interpret the concept of God. They are just ultra power beings on different sides of the conflict.
So if these gods are powerless, then they not like God. People call the gods just because they are very very powerful. But they don't have the omnipotence and omnipresence that characterizes God.
I fail to see a difference, but properly answering your argument here would likely violate the board rules. There are numerous other views in theology and philosophy then the Christian one, you should study some other faiths and philosophies before making broad statements like this.
Record of the Lodoss War and the other Forcelia works are High Fantasy, and have no supreme being at all. They don't even really have much in line of deities period really, and I can only really think of one case where one actually interveined, by sending a priestess a one sentence message. Sure, priests and priestess cast spells and they're different sorts then the wizards, but they cast them the same way.
Although it is not, strictly speaking, High Fantasy, many elements of Journey to the West do fit into similar conventions and it has all of the gods and demons subservient to an enlightened man (and later on, an enlightened monkey).
High Fantasy does not require a prime actor, and is not an inherently Abrahamic exercise in morality. Especially since the general concepts of good and evil employed in most are inherent to the human condition, rather then any particular faith. In many cases there's no actual discussion of why the Dark Lord is evil, he just is.
From this point of view, all literature would be point-less.
No, different authors write for different reasons. Tolkein and Lewis wrote because they wanted to. Conan Doyle wrote because he wanted to. None of them needed to write to support themselves. Howard, Lieber, C.L. Moore, etc wrote because that was wanted to so
and in order to support themselves. Proper analysis and critique of a work is helped by understanding the author's motivations for writing a piece. In the case of Conan and many other S&S stories when the genre began, it was to feed themselves. Much like a script writer churning out action movie scripts.
That said, even if the motivation was to make money (note this was Rowling's motivations in Harry Potter, which is High Fantasy), that doesn't make it any less entertaining. Which, contrary to what many academic fiction authors think is the point to writing a book.