Luke’s instinct is to destroy the texts, and Yoda confirms that this instinct is correct. The texts were dry and boring and what really matters is the Force itself, because it alone will guide you. Rey needs to look forward, not backward, if she is to succeed.
But Yoda didn’t destroy the texts, they’re aboard the Falcon at the end of the film.