Software does need to stop linking to these tar files.
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.
Just stop distributing binaries, it's unprofessional.
You need to then secure the source, handle security concerns, install AV, you might as well use windows or OSX which have extensive controls for these things already inplace...
It's convenient, but unwise.
With that said/considered, I don't think it's a big deal - anyone non-technical should be happy with whatever their distribution maintainers provide.
They won't be watching mailing lists hoping to grab the latest $thing :)
But “desktop Linux” is not an entity that can solve anything. It’s a loose collection of people and organizations all doing their own thing. If Thunderbird gives you an installer on Windows and an archive full of files rather than an installer on Linux, well…