Disgraced former leader of the Scottish Catholic Church will retain title of cardinal but won't exercise any of the privileges associated with the office.