I suspect Spiderman 5, will be lower stakes post SW when the MCU is "reset " .
But again, that's what I suspect.
But , ultimately ,It will depend on how the audience responds to SW , i.e. if they eat it up Box Office wise, or if audiences are done with the Multiverse stuff post SW.
At the end of the day , that's what the studios are going to react to .
So, even though the intention right now, may be , " We'll do a grounded Kingpin / Daredevil Spiderman film post SW .", things happen, and plans change, so there's no guarantee come 2028,
that Marvel and Sony will desire to go that route for Spiderman 5.
I hope they do , but , this is Hollywood.