Here are some other examples of Bible characters being fuckups:

Noah and Ham
After the flood, Noah plants the first vineyard, and (understandably, after seeing everyone killed in a flood) gets shitfaced to the point where he passes out naked, where Ham finds him. Ham tells his brothers and they walk backwards with a sheet to cover his shame. Noah wakes and realizes what happened, somehow knowing who found him, curses Ham.

This story is very confusing until you realize that the phrasing used - that Ham "uncovered his father's nakedness" - is a euphemism for sex found elsewhere in the Bible (Leviticus 18). In other words, Ham raped his own dad while he was passed out. huh

David
When looking out from his palace he got a boner for a smokin' hot babe, so he had his servants bring her back and he slept with her. Afterwards he found out that she was married, and that her husband was a soldier. David devised a scheme to get rid of her husband; before a battle he ordered that the husband be placed on the front lines where he would be killed, which he was. So David becomes an adulterer and murderer, which he repents for.

Moses and Aaron
When the Israelites were out of water, God instructed Moses and Aaron to speak to a rock to make water miraculously pour from it. Instead of following God's instructions, Moses strikes the rock with his staff. It works and they get their water, but because they disobeyed God Moses and Aaron are told that they will not enter the promised land.

Aaron's sons
Aaron's sons, who are priests, offer "strange fire before the Lord" and are consequently immolated by God.

Jephthah
Jephthah a vow to God that if he won a battle, he'd give the first thing that came out of his house as a burnt offering to God. He wins the battle, only to come return and see his daughter exit the house. He laments that now that he made a vow, he cannot break it. He sacrifices his daughter.

Jeremiah
While not exactly presented as a sin, Jeremiah hates being a prophet and is practically suicidal.
>O Lord, thou hast deceived me, and I was deceived; thou art stronger than I, and hast prevailed: I am in derision daily, every one mocketh me.
>Cursed be the day wherein I was born: let not the day wherein my mother bare me be blessed.

Peter
Famously denies Jesus three times.

Paul
As a Pharisee, Paul was a zealot who persecuted the early church, for this reason he called himself "the least of the apostles". As a Christian, Paul confessed that he continually struggled with sin.
>For that which I do I allow not: for what I would, that do I not; but what I hate, that do I.
>For I know that good itself does not dwell in me, that is, in my sinful nature. For I have the desire to do what is good, but I cannot carry it out. For I do not do the good I want to do, but the evil I do not want to do—this I keep on doing.
Many also speculate that the "thorn in his flesh" from the devil was lust or another sin.