After I choose to discard a card to Insightful Investigator, does my opponent still have to reveal the new card they drew?

No. Reveal applies a temporary modification to a defined set of cards. The hand stays private as a zone; new cards entering it stay private unless something says otherwise.