[CI] AMD64 macOS 12 Python 3 is failing on CI due to failing to upgrade c-ares from brew

[raulcd]

Describe the bug, including details regarding any error messages, version, and platform.

As seen on this job:
https://github.com/apache/arrow/actions/runs/7043964332/job/19174051564?pr=38820

The following error is happening when installing dependencies from brew bundle --file=cpp/Brewfile.

==> Upgrading 1 outdated package:
c-ares 1.22.0 -> 1.22.1
==> Downloading https://ghcr.io/v2/homebrew/core/c-ares/manifests/1.22.1
==> Fetching c-ares
==> Downloading https://ghcr.io/v2/homebrew/core/c-ares/blobs/sha256:245fda65de52dff4d56b8d876fc2e63de23196ac7364b67988657fb5b6a81af7
==> Upgrading c-ares
  1.22.0 -> 1.22.1 

==> Pouring c-ares--1.22.1.monterey.bottle.tar.gz
🍺  /usr/local/Cellar/c-ares/1.22.1: 153 files, 777.4KB
==> Upgrading 2 dependents of upgraded formula:
Disable this behaviour by setting HOMEBREW_NO_INSTALLED_DEPENDENTS_CHECK.
Hide these hints with HOMEBREW_NO_ENV_HINTS (see `man brew`).
mongosh 2.0.2 -> 2.1.0, node@18 18.18.2 -> 18.19.0
==> Downloading https://ghcr.io/v2/homebrew/core/node/18/manifests/18.19.0
==> Fetching dependencies for node@18: openssl@3
==> Downloading https://ghcr.io/v2/homebrew/core/openssl/3/manifests/3.2.0
==> Fetching openssl@3
==> Downloading https://ghcr.io/v2/homebrew/core/openssl/3/blobs/sha256:f7a40a7805a08e891793c39a924f5bce301a0d7b9e9d822ca02d88bd74bc7dce
==> Fetching node@18
==> Downloading https://ghcr.io/v2/homebrew/core/node/18/blobs/sha256:4cfca9589e628b6bdc5afe86624c57c134ba9a7e35e58fe8d24b3be8f76e5af9
==> Downloading https://ghcr.io/v2/homebrew/core/mongosh/manifests/2.1.0
==> Upgrading node@18
  18.18.2 -> 18.19.0 

==> Installing dependencies for node@18: openssl@3
==> Installing node@18 dependency: openssl@3
==> Downloading https://ghcr.io/v2/homebrew/core/openssl/3/manifests/3.2.0
Already downloaded: /Users/runner/Library/Caches/Homebrew/downloads/f4198e1c20f075acafccf58da7f0da06963e40006c4c127cbc667a85750039df--openssl@3-3.2.0.bottle_manifest.json
==> Pouring openssl@3--3.2.0.monterey.bottle.tar.gz
Warning: These files were overwritten during the `brew link` step:
/usr/local/bin/openssl

They have been backed up to: /Users/runner/Library/Caches/Homebrew/Backup
==> Summary
🍺  /usr/local/Cellar/openssl@3/3.2.0: 6,805 files, 32.4MB
==> Installing node@18
==> Pouring node@18--18.19.0.monterey.bottle.tar.gz
Error: The `brew link` step did not complete successfully
The formula built, but is not symlinked into /usr/local
Could not symlink lib/node_modules/npm/bin/node-gyp-bin/node-gyp
Target /usr/local/lib/node_modules/npm/bin/node-gyp-bin/node-gyp
already exists. You may want to remove it:
  rm '/usr/local/lib/node_modules/npm/bin/node-gyp-bin/node-gyp'

To force the link and overwrite all conflicting files:
  brew link --overwrite node@18

To list all files that would be deleted:
  brew link --overwrite --dry-run node@18

Possible conflicting files are:

Component(s)

Continuous Integration