The short version is that solids have merely ok heat capacity. The molar heat capacity of many solids at high temperatures is approximately 3R or approx. 25 J/molK. Google "Dulong-Petit Law" and "Debye Model" if you'd like to see why.
By comparison, the polar molecule water, which has extraordinarily good heat capacity, due in part to hydrogen bonding, is 75 J/molK at room temperature.
So water has almost 31x the heat capacity of tungsten by weight.
It may be I'm missing some obvious implication of something you've written that I've missed due to negligible background here, but I'm confused by the numbers you've cited here.
You list many solids as having a molar heat capacity of "25 J/molK", water as having a molar heat capacity of "75 J/molK", and conclude that water has almost 31x the heat capacity, but naively comparing the numbers cited only gets you 3x. Where does the other 10x factor come from?
By comparison, the polar molecule water, which has extraordinarily good heat capacity, due in part to hydrogen bonding, is 75 J/molK at room temperature.
So water has almost 31x the heat capacity of tungsten by weight.