That KB entry is misleading: Steam works on most distros (at least all the ones that I've tried) because it includes its own runtime (glibc etc.) and thus avoids most of the idiosyncrasies of distros.
AppImage/Flatpak/Snap/Docker is mostly the same idea, just executed differently.
Yeah, it speaks volumes that the best way to ensure applications work on your platform is for the dev to bundle their own version of the platform in a container with the application.
...those are called folders. DOS applications worked that way. Only UNIX people seem to think that not hardcoding all your paths is some kind of special voodoo.
Oh, you meant that they package the libraries with the application? Yeah. If it isn't part of the base system, they do. That's how it should work or you get DLL hell.
Problem with Linux Desktop is if you put any two of its community in a room you'd have 4 different incompatible base systems within a week.
It's a trick question without a clear answer.
Many people tried, noone has ever succeeded.