Forget all data sheets: they can only calculate the product properties as such – but these are not "absolute," rather they shift considerably depending on the processing. Especially sound bridges are often small workmanship flaws or planning errors with big impact, which far exceed the "decibel" value differences between building material X and Y.
There are several reasons for lightweight walls. A main reason is labor costs for walls that have to be adapted to sloping roofs: in the past (with less insulation in the roof structure) one built "stepped" masonry, today walls have to be cut in a straight (slanting) line. This is more complicated with "solid construction materials" than with cladding of stud walls. In "lightweight construction" this can be done by considerably cheaper helpers. Another (weighty) important reason is that for non-overlapping walls it is advantageous if the "upper" walls are light. These two reasons concern houses with classic sloping "attics."
But even in the straight-walled "upper floors" of "city villas" one often uses "truss rafters," which in contrast to the common rafters span freely without "load-bearing walls" (as long as one does not want to make the top floor ceiling out of concrete).
Some walls are needed for the statics, not all architects are aware of that.
That one about statics was good^^
Yes, indeed: there are actually more and more architects who only think about load-bearing of weight and neglect the bracing effect against wind load.