Former Sydney councillor Nick Adams has been dropped from a key US diplomatic role despite being an avid Trump loyalist.