SNP Westminster leader admits he ‘got this one wrong’ amid internal party row