Audit atomics and use weakest ordering possible

As discussed in https://github.com/timberio/vector/pull/6428#discussion_r577777055 we should use `compare_exchange_weak` where possible. It's worth taking a passes through the code to find opportunities for weaker ordering.  