The average person never sees this stuff. Linux is widely used as a server OS and it still has taken a long time for new appraoches to get traction.
That's true, but also irrelevant. The file system can be a mess on MacOS because most MacOS users will never actually interact with the file system in any meaningful way. Apple obscures the file system away from its users by design. If you ask the average Mac user where on the computer their files are stored, they'll likely tell you something like, "They're all in the Photos app". On the other hand, even a fairly novice linux/unix user will almost certainly end up interacting with filesystem directly at some point, probably a lot.
The Unix under the hood is just standard stuff and Apples hides away detritus like .plist files. And sandboxed apps have their own little stub filesystems too.
Anyway I like the idea of GoboLinux a lot but kind of think GUIX, just abstracting it away might be the right approach.