The character is too optimistic, and idealistic for most modern writers, so we wind up with a bunch of stories about breaking down the tropes of the Superman myth. Batman fits the general world view of most modern writers better, that’s why he has overtaken Superman in recent years.
Superman, and Shazam are “child-like wonder,” characters and increasingly that is something that modern superhero writers find hard to write.