and people like you dont understand that y-class Civilized worlds are by far the most common of all the types
on the same page you posted,
(from a book that isn't even a lore book or codex, but a supplement book of urban conquests for the table top,)
"hive worlds only make up 10-25% of worlds,"
while majority of the worlds in the imperium are y-class,
and y class rarely have hives simply because y-class are self sustaining civil worlds, especially the once with no larger industry that can sustain hives,
for hives need to import food and resources,
while y-class are mostly self reliant civil worlds.
and this is commonly shown in many older books, like Eisenhorn with his estate on Gudrun, described as a world of stately manors, rolling green hills, small villages,
and Caiaphas Cain who constantly gos to backwater planets, and non-hive environments where people have jobs, pastimes, local governance, and relatively mundane (if regimented) lives.
meaning that not all of the imperium is a desolate hive cluster industry, that would be just purely unsustainable,
what we're shown is are the war-torn and overpopulated worst of the worse worlds/sectors, because that's where the most of the drama and conflict rises,
but the rest of the impirium is just "normal" urban cities.
Too many people don't realize that "over eight-five percent of the million worlds under Imperial control have at least one hive city cluster" (Urban Conquest, 2017, Studio). These same people seem to think civilized worlds are just like Earth today or that hives aren't hellholes.