Lack of female executives in UK boardrooms ‘appalling’, survey finds