You know I'm asked this question a lot and here is my suggestion - get it.
It isn't about if you are going to haul it or the carrier requires it but rather that you put an effort into learning a bit more than what you need to get by to get a CDL. One fleet owner here won't consider anyone without it, while I know others who feel that it seems to make drivers just a bit more aware of what they are hauling.
Personally, I would like to see that it is not an endorsement but a requirement for a CDL as much as the Smith System also become part of the CDL licensing.
Risk?
NO more risk than hauling dry freight if you are thourough in securing the cargo and driving sanely (not like the FedEx driver who passed me on I80 yesterday doing 75 and passing everyone in his way).
Doesn't matter how carefully my freight is secured or my driving is, if the other guy is reckless.
Like the FedEx Freight truck pulling doubles in the [prohibited] left lane last night - nearly caused an ambulance [with lights & siren] to wreck - silly emergency driver thought the big truck would move to the right, but he didn't.