There's a difference between having a few choice possessions and being obsessed with having lots of things.
Anywho, Picard's attitude may be a bit snobbish but it is realistic. I mean, if a guy today ran into a French Aristocrat do you really think he'd be totally okay with them? He'd probably think "Whoa, those frogs sure dressed weird and acted weird. Glad we're not like that."
Modern people will always see themselves as superior to their predecessors. Trek was fairly realistic in having the 24th Century people not be worshipful of 20th Century people.
Well, Janeway did admire Amelia Earhart (her hero from the 20th Century). However, the TNG people didn't seem much impressed with Scotty (a man known for his exploits with Kirk in the 23rd century). On the other hand, Jadzia was overjoyed to see Kirk, Spock, and Koloth when she went back in time to the 23rd century. And, Sisko took time out to meet Kirk personally in his own way before he left said mission in the 23rd century.