A key charity has dented the campaign for a tax on sugary soft drinks in the US by pulling its support for the policy.