That isn't always the case, and is one of the driving themes of Miyazaki's games: unreliable narration and corrupted ideals. So, like yes; the "gods" are real but their power or God status isn't always what it appears to be. In some cases, the power people sought through their faith, brought them to total ruin when it wasn't all glitz and glamour as they were told. Like people who tried to become dragons but ended up as weird mutant half dragon things. Or Rosaria's Fingers that eventually turn into giant maggot things. Faith is very often rewarded with body horror in Dark Souls, Bloodborne, Elden Ring and even Sekiro.