Tyvek is a water resistant barrier - its purpose is to reduce wetting behind your siding (whatever it is) and it is slightly vapour open to allow moisture to escape if the wall assembly does get wet. Think of it a bit like gore-tex; water doesn’t get in but some vapour can get out. Buildings are ok getting a bit wet - it’s generally only bad if they can’t dry out.

Tyvek can also perform as an air barrier if detailed correctly but that’s not what you’re seeing on most residential construction.

Older buildings don’t usually have a vapour barrier and it’s not an issue because they are also poorly insulated and draughty. So they tend to dry out.

In a better insulated house that’s relatively air tight, problems occur where warm air meets a colder surface and you get condensation. Could be warm outside air meeting cold interior surface if you have AC. Could be warm interior air meeting cold exterior surface if you have heat blasting on cold days. If that condensed moisture gets trapped and won’t dry out, you get rot.

So - your 60 year old house that’s rot free is probably fine, but may be an energy pig. If you update it with better insulation and make it air tight to lower energy costs, that’s when you need some advice to get the details right.