DHH is misusing the term “red pill” here. He’s saying he’s accepted an inevitable negative outcome, not that he’s been exposed to a hidden truth. The term he’s looking for is “black pill.”
To be fair, glancing at the usages of red/blue pill in the script, they are using the term in an intuitive way; minus connotations as of late. Culture (some might argue a subset of culture, be it large or small) has just further defined and added connotations to the different kinds of "pillings." In a general sense, I would agree with you.