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.