Actually, Homebrew 7 is supported on your Mac, you just have to install Linux to use it. :)

If you want to continue using the same MacBook that will be only path forward when Apple decides to EOL it (if it hasn't already happened).

I'm a long time Homebrew on Linux user, it works really well. I always prefer it over the distro supplied package manager for user facing CLI apps.

Apple was selling Intel Mac Pros in 2023, it's absurd these things are coming up on EOL already.