It is possible for rpms and Deb packages to contain repos in them, see the vscode packages, it’s just a matter of how developers choose to distribute their software. This is getting alot better with things like Flatpak, Snap and to a lesser extent AppImages