Former Yorkshire cricketer Azeem Rafiq has told Sky News his family members in the Rotherham area have felt unable to go out and live normally amid the "frightening" violence.