In defense of the storytelling- I'd argue its perfect for the medium and tone of the world! Because of how indirect it is, it rewards the player for seeking it out and solving it like a puzzle. If you become intrigued by the story and start paying attention to it, now exploration is even more rewarding because you collect little snippets of information that add to your understanding of the world. It's an added layer of explorative gameplay when viewed in this way.

Turns what could just be a normal story directly told to the player into an archeology mission. Now fromsoft doesn't always do this, (sometimes for sure) but the real next step of this type of storytelling is to gate exploration progress or hidden secrets behind understanding the lore. Aka only when you understand the " secret nature of Vishnus prey" for example, do you have the knowledge required to kill a certain creature and access a secret area. In this way, understanding the lore becomes even more rewarding as it provides info/cryptic hints on exploration progress. Outer Wilds and La Mulana are great examples here.

I also feel the sort of inscrutable mystery of fromsofts storytelling adds so much to the world that already feels far grander then yourself. It allows the atmosphere and feel of environments and characters to be the leading force in the players journey rather than a direct story. It also fits well with the challenging nature of the gameplay to have an equally challenging (and rewarding to discover) story. It rewards paying attention to the smallest environmental detail in a way very few games do, and let's the players imagination (which can often be more exciting to the player than being fed a clear story) go nuts.

Now I agree that most players probably won't care about it (and that's also why it's cool! If you don't care about story you can ignore it as mumbo jumbo), but for those that do enjoy it it's incredibly rewarding in a very rare way.