Neil Gray fails to back trans-row nurse as SNP 'moral cowardice' leads to Holyrood chaos