The issue here was fully on the AUR’s PKGBUILDs. No upstream code involved.

as better alternative for these formats or is this just xkcd for package formats

It can be both. But in this case I see they reuse system libraries, which goes against the idea of ending dependency hell. Apart from that, I don’t see any advantage with respect to snap or flatpak.