As this discussion makes clear, there are plenty of great options out there. Many of those have made overtures toward subscription offerings, too, so that's still the general trend. Because Affinity is really after Adobe's vast publishing market, they remain steadfast in keeping it a relatively cheap one-time purchase per major version. This lets them attract punters and build up their customer base.
Adobe's revenue from photographers is "spare change under the cushion" compared to its other target audiences, such as publishing, targeted advertising, and marketing analytics. Of course, Adobe's genAI capabilities, while perhaps interesting in photography, have vastly more profitable use cases in other areas of graphic design and publishing. Long story short, they're not likely to change the terms of their subscription services any time soon, especially since they make money hand-over-fist. They're a vast empire of tools and businesses, of which Lightroom is a tiny part, Photoshop itself notwithstanding.
I keep an Adobe subscription because I love Photoshop and am used to it. If I need to stop subscribing at some point in the future, there's Affinity (at least for now). Many of the newer subscription offerings either offer a dual approach—subscriptions for the latest and greatest or a one-time purchase with minimal upgrading (a year at most, generally). Capture One, my own preferred raw converter, and Photo Mechanic fall into that category. Other companies are just toying with subscriptions right now but you can tell they like the idea for obvious reasons.
Choose your poison 😎 .