First off, the premise for your thread is objectively dumb, so there's no way to have a genuine discussion given the premise is such a failure.
Secondly, what metric are you going by to assume Sony has "failed" to create anything like Zelda? Sales-wise? Most Zelda games outside of BOTW "only" do around 10-15 million, Sony has several games across a few IP that have done around that much or more. In terms of influencing game design? I think Gran Turismo, TLOU, and GOW 2018 are three obvious examples of games/IP which have had massive influence on various game design trends over the years, if you think otherwise you're being extremely foolish.
Do you mean artistically? Games like Ico and Shadow of the Colossus take aspects of fantasy aesthetics and do some pretty novel things like them, their influence can also be seen in a few various games. I would not even be surprised if Shadow of the Colossus was a particular inspiration for Zelda games like BOTW, there are certain worldbuilding and thematic elements similar between them.
So the entire premise of your thread is just a complete failure because you don't even quantify (at least in the OP) what metrics you're going by to define what Sony's Zelda should be. If it's literally just copycating Zelda wholesale, then yes they have tried that before with games like the Dark Cloud series which have their fans but didn't set the world on fire. However that's such a dumb metric because it would enforce unoriginality and have unrealistic expectations. By your logic, why has Nintendo utterly failed to make anything approaching Gran Turismo, or God of War, or TLOU, or Spiderman? Why do they have no games that meet the visual bar of titles like Returnal and R&C: Rift Apart?
See how short-sighted your premise for this thread actually was?
I've got not axe to grind with Zelda but the OP clearly wasn't thinking things through here. Nintendo have their way of making games, Sony have theirs.
TBH any metric someone can try saying Sony's games fail at compared to Nintendo, you can generate just as many for any of Nintendo's games that fail compared to Sony's.