I mean, I don't run any billion dollar companies, so what do I know, but Apple donating a couple of million to ensure that Homebrew stays active seems like a no-brainer investment to me.

Yeah, Homebrew has been doing this work for free thus far, but open source projects die all the time. It's very much in Apple's interest to ensure this one doesn't.