The value of the money market fund is not insured, no, but the failure of the brokerage is. That said regulations are significantly stronger now for MMFs than they were when pre-2008. I guess it depends on what you're trying to protect against exactly. [1]

[1] https://www.sipc.org/for-investors/introduction