1) in retrospect it was obviously incorrect, and
2) even at the time, a reasonable scientist could have concluded that it was flawed
I don't generally call papers "flaming garbage", but some are so egregiously, transparently awful -- at the time of publication -- that saying otherwise is dishonest. That MMWR study was one.
Your only complaint relevant at the time of publication was people that where vaccinated acted differently, that’s also true of the study you linked. It wasn’t double blinded making it “hot garbage” by your logic. Presumably the only reason you linked it was it didn’t contradict your assumptions, even though it failed to address the actual question of how useful post COVID vaccination is.
Except we care about real world outcomes so a double blind study would be less relevant making your original complaint pointless.