I see that Rabbi Betsalal Friedlander has established a group with a large membership to study tanach. This reminds me of a story about the Gaon Rav Yaacov Kaminetsky. Once a person was showing off his ability to know tanach, and he was proud of himself and his knowledge. Reb Yaacov who had learned thoroughly Tanach dozens of times, turned to him and began testing his knowledge of Tanach and that was the end of that session with the "expert."
In truth, I find that the study of Tanach is a very sensitive thing. One thing that bothers me very much is when passages in the Torah Neviim and Kesuvim offer strong criticism on great biblical people.
Let us discuss the biblical teaching in Melochim (kings) about Shlomo HaMelech, about Solomon the son of King David. It begins "and HaShem gave wisdom to Shlomo as He spoke to him about it." In chapter 8 passage 22 we find the great prayer made by Solomon in public to HaShem. But a few passages later we are given the statement of HaShem that only by true piety can Solomon merit the greatness of ruling the Jewish people. There is a threat not to be unfaithful to HaShem, which later on was to happen.
We find in chapter ten passage 11: "And the King Shlomo loved many strange women and the daughter of Pharoah...from the nations that HaShem forbade the Jews from marrying....with them Solomon was close with them in love." The passage then tells how Solomon was influenced by these foreign women to sin against HaShem. It seems that these strange women turned Shlomo against HaShem. "and Shlomo did what was evil in the eyes of HaShem."
And yet, Solomon produced great literature and built the Beis HaMikdosh. But he also did very serious sins. Yes, the study of Tanach is a mixed bag, unfortunately.
Actually, the mistakes of great Jews is a central theme of the Tanach. But it is painful to have to read about the terrible sins some great Jews committed.
Those of us like myself who have intense pain from parts of Tanach have a problem. The Torah tells it like it is. But that story is the whole story, leaving out nothing of the good and the bad. The story of the Jewish people and their great leaders is a very sensitive project.
One idea is that yes many great leaders did some sins, but if we as a Jewish people lasted so many centuries, perhaps these people who sometimes sinned had a lot to do with it.
I don't know a good explanation for the terrible sins of the greatest Jews. I could mention some teachings from various sources, but let us leave it for now, and accept that we as a nation survive all of the sins committed by people who shock us when they do these sins. And that requires a separate study and who knows if today anyone has the proper approach. Maybe the Malbim has succeeded there. Or maybe we can just keep things simple. The great Jews had tests from the Satan and sometimes they failed. And maybe they did penitence.
We know that Aharon was punished for making the Golden Calf, and he was as pious as his brother Moshe. But Moshe went to heaven regularly to talk to HaShem, and Aharon was blamed for the terrible sin of Jews worshipping the Golden Calf. Because Aharon was great, his sins are clearly spelled out and described. But who could have done better than the greatest saints?