It's about as similar to the 'download untrusted software, double click to run it, and hope/pray/assume it handles updates itself' workflow found elsewhere as you can get.
I have several non-technical family members using Linux. They don't struggle getting software at all, regardless of it not being just-like-others.
There's software portals just like the stores on other platforms and they generally bridge the gap between packages/containers well.
Nobody installs from archives like Slackware anymore, or they shouldn't.