Cases are collapsing because of a lack of support being given to children ahead of the stresses of giving evidence in sexual abuse cases in court, the NSPCC said.