I understand that the current FCC is basically intentionally toothless, but that wasn't the case a few years ago, and doesn't necessarily need to be the case a few years from now.
Granted, it's not too bad for Tor browser, where all browsing sessions are strictly anonymized and JavaScript access is heavily restricted so MITM attackers are limited in what they can do provided you never transmit anything sensitive or download any files over plaintext, but for general purpose browsing I definitely wouldn't recommend it (even ignoring the performance issues).
Of course if somebody has none of these concerns, the Firefox Private Network is optional and they can decide not to use it.
And if you are in the US and your ISP is not Comcast, then it's probably Spectrum, ATT, Charter instead. Not highly trustworthy companies either
Simply connecting to these hotspots opens you up to location tracking unless you're able to randomize your MAC address, but after you connect it seems like common sense to prevent these companies from harvesting your browsing data as well.
(where "browsing data" is defined in both cases by the contents of DNS requests)
At minimum I'm more likely to trust that Cloudflare will uphold their contract with Mozilla than that my ISP (Spectrum) isn't happily selling out my browsing data -- and the ISP, unlike Cloudflare, knows my name and address.