Homebrew has always kept itself separate from the OS (using /usr/local as a prefix), and SIP has already prevented you from modifying OS files for several years

Homebrew has always kept itself separate from the OS (using /usr/local as a prefix), and SIP has already prevented you from modifying OS files for several years, unless you turn it off. So I think nothing happens to Homebrew at all.