I think most of the big developers will continue their practice of supporting the last three macOS versions. And then it gets very ugly very quickly for any older OS.Security updates don't guarantee compatibility with apps from Apple and third-party developers, especially following a major architecture change. If they did this would be a non-issue.
The small, Mac-only developers are... a bit of a different story. I could easily see them wanting to only support the latest version or maybe one more. Had that happen with one or two apps on Ventura on my 12", which is one of the reasons I OCLPed it...