Yes, you're right. From developer perspective, I do agree. From customer perspective, we had Affinity v1 supporting macOS 12 Monterey all the way down to OS X 10.9 Mavericks. That are altogether 9 (nine!) supported different macOS versions from Affinity apps, including around 7 operating systems that Apple didn't support anymore. Not so long ago even OS X 10.8 was still supported by Affinity. With the release of Affinity v2, we do have a huge jump of minimum system requirement from OS X 10.9 to macOS 10.15. That are 6 system versions difference and that's a lot.
I do agree with your security concerns, but there are many ways to get a reasonable security even on older OS versions, like using modern third-party browsers, mail clients and firewalls, etc. There are good reasons for keep using older system releases, too. If you want to be productive, you'll need a system that just works. You don't have the time to spend every weekend in installing latest OS versions, fixing important broken workflows or dealing with latest OS bugs. I'm still using old macOS versions as I'm still using Adobe Creative Suite in parallel to Affinity apps. Adobe CS doesn't run anymore on macOS 10.15 and I don't want to be forced to Adobe subscriptions. Indeed, that was a main reason for my transition to Affinity apps. I know there are more people, that want to keep their Adobe CS AND want to use the latest Affinity apps until the transition is complete.
I like all the Affinity apps and I'm sure that those will become my main tools in the near future. Meanwhile I don't ask for supporting OS X 10.9. Supporting macOS 10.12 would be my wish and would be a really great thing. At least supporting macOS 10.14 would do me a big favor, making my personal transition from Adobe to Serif more comfortable and smooth.