Sale to go ahead after lawmakers unable to override veto on bill blocking $8.1 billion in weapons sales to Riyadh, Abu Dhabi despite bipartisan concerns