While there is still lot limitation using only flatpak, snap or appimage, i believe that in the next decade they will slowly grow and end up that packaging nightmare.
So we can have an OS up to date, latest app without worrying any breakage. But i’m not well versed and dunno if people and dev will follow that road.
I think it’s time to ditch apt, dnf, rpm, aur. I imagine it would ease dev work but i’m not sure.