I don't find that it keeps the liquid any cooler than a bottle, all things being equal. In fact, the first sip is often rather warm from having sat in the tube.
Disclaimer: I don't much like cold drinks so I don't bother with ice cubes or special CamelBak's that purport to keep things cold.
Paul