Enable async_socket_for_remote by default to optimize Distributed tables querying

Enable async_socket_for_remote by default (lower amount of threads in querying Distributed tables with large fanout). #23683 (Nikolai Kochetov).