You are totally right IMHO, non-technical users won't want to know what kind
of software is on their machines, they just want it to work. That can become
a problem when, for example, a website X demands a specific tool that
requires an update or another OS (like Facebook and Flash), but once again
this is something totally different.
I think that, even non-technical user, if they get a little bit interested by
what they are using, they will notice, for example, the new Gimp that is out,
and they will ask why they don't have the same, this may be a problem, but
once again, they have a solution for it (even if this isn't of the like of
everyone xD).
In my opinion some software should be updated more often and others not. I
mean, I personally don't need a rolling distribution for nothing, I rarely
need something the second when it's out xD But I don't want to wait 6 months
or 2 years just to update Gimp or LibreOffice (LibreOffice is the real
problem, since every version brings new compatibility with Microsoft Office
documents, and this is very important to everyone that have to open them). It
doesn't need to be out at the second, but 3 months maximum is a good date for
a non-LTS distribution.