I don’t know why Thunderbird can’t get a reliable, functional search ability. It’s such garbage. I constantly have to delete my entire search index and start from scratch, it is immensely frustrating.
Maybe see if Betterbird’s search works better for you