Due diligence usually refers to the review of the asset you're trying to acquire. There weren't any significant surprises about Twitter's state. Elon's issue was Elon.
As I just argued, due diligence wouldn't have uncovered any surprises. It's merely that Elon could have used the process to ascertain what consequences the acquisition would have for his own assets (compatibility/marketing audit) and what his ideas would lead to.