It is useful, if nothing more, as a good consciousness raiser about how the world treats sacred things.
The classic interpretation of Noah’s and Moses’s actions as being inspired by a purposeful God is out the door with the world. No, they have to psychoanalyze these folks, and they can’t come up with a theory that explains everything. So they invent stuff. Moses’ brethren and Pharoah thought Moses was crazy, so the modern world thinking him crazy too is hardly news.
I don’t recall reading in God’s Word that he was thought to be crazy.
I don’t believe they psychoanalyze God’s prophets, apostles, disciples, or followers. They accuse these historic figures-often times- of being “Schizophrenic” in order to discredit their testimony and character.