Durability depends on weight but ALSO (even more so) on fiber's quality and strength.
A common misunderstanding is that "thickness equals durability". Not that simple.
Some very light prints can actually be upholstery rated and quite durable:
Enchantes is about 0.25lb/yard thus quite light!
but more durable than retail quality cotton at 0.5lb/yard:
Weight is just one factor for durability.
Other factors also matters and sometimes greatly so!
Fiber quality (higher grade also means more durability. Higher grade cotton or silk cost a lot more than common or poor quality ones)
Thread counts (the denser the more durable),
Fiber type (wool, mohair, linen and quality cotton are in general more durable than silk or common polyester).
At last, fabric treatment : fabric has been treated to strength its durablity after the weave process.
All these matters.
As a matter of fact, lots of retail upholstery fabric, "thick and heavy" to inexperienced eyes, it won't last for more than 5-10 years, while a designer thin and light weight cotton print or silk will still shine after 20-30 years!
A good quality linen or cotton at 0.5lb/yard, like Pashmina, is actually more durable than a rayon or polyester retail fabric at 1lb/yard.
Another example:
This Italian cotton percale is even lighter than Pashmina and feels like a shirting fabric, ,light as 0.3lb/yard, but it is actually very durable. More durable than a lesser quality piece at 0.5 or even 1lb/yard. It will hold up easily for 30 years!
K'ang Xi, a light weight and thin cotton percale, was proudly used by Brunschwig & Fils on a chair:
