In twenty years, I'll just be sitting here running Debian, watching distros come and go.
(Twenty years ago, I was actually running Debian, watching distros come and go, although I had a dalliance with Gentoo, don't tell Deb or Ian.)
That said, just use flatpak
I am not looking elsewhere since I realized can't stand gnome, but the idea of aeon is probably the most solid I have ever used, at least for desktop use.
I haven't really decided where to go now except for away from gnome, but Bazzite looks promising, and maybe the new KDE Linux ("project banana") in some time.
it should be like Aeon but with KDE
That's pretty much what you see in the chart in the article. Debian share remains untouched over time. Not affected by trends.