[C++] Make ConcurrentQueue and BackpressureConcurrentQueue public interface

[gitmodimo]

Describe the enhancement requested

Both queue are useful for writing custom acero nodes. Making them public reduces code duplication.
This is a follow up to #45652 that clean-up queue interfaces.

Component(s)

C++