here's a study that found that brita-filtered water contained more bacteria than the tap water only a week into the filter's service life: https://pubmed.ncbi.nlm.nih.gov/8740859/
I used to be a religious brita user, but now I just stick to tap. hard to assess the relative risk, but it's cheaper than buying filters.
I use Zerowater and I can tell when it gets a slight smell (bacteria I assume) , I just change the filter at that point even if it hasn't been ~3 months.
Unless the bacteria is actively causing harm or a variety known to be harmful to humans I'd still rather take my chances with the filters.
like I said, hard for me to do a good comparison of the relative risk, but that sounds pretty bad too. some bacteria is normal, but this is like drinking from a stream vs drinking from standing water.