וּפָנִ֤יתִֽי אֲנִי֙ לִרְא֣וֹת חָכְמָ֔ה וְהוֹלֵל֖וֹת וְסִכְל֑וּת כִּ֣י ׀ מֶ֣ה הָאָדָ֗ם שֶׁיָּבוֹא֙ אַחֲרֵ֣י הַמֶּ֔לֶךְ אֵ֥ת אֲשֶׁר־כְּבָ֖ר עָשֽׂוּהוּ׃

For what will the man be like who will succeed the one who is ruling over what was built up long ago? My thoughts also turned to appraising wisdom and madness and folly.

It mentions the reference to "outthinking" Hashem applies to Moshe here (questioning the reason why Hashem wasn't helping the Yidden per Moshe's reasoned way) and Shlomo Hamelech who thought the mitzvah for a King to limit his wives was only due straying away from Hashem. Reasoned Shlomo, I can have many wives and not stray thus maintaining the point of the mitzva.
Both are huge failures - Moshe (see Rashi 6:1) is now not able to see the conquering of Eretz Yisrael. And Shlomo, forgetting where in the Gemara, says that when he married Bas Pharoah that the foundation of Rome was founded. Nonetheless, Hashem sees the tzaar of Klal Yisrael and reacts with Rachamim.

I'd like to say the following. When we do averios and things that are wrong, we feel bad. And when we get chizuk that's it all going to be ok or get dragged into thinking all will be bad - either way we ask - but we did so many bad things what now? 
Moshe Rabbeinu hadn't even got to Makkah Numero Uno, and he already knew his leadership would be lacking at the end. Shlomo started in part the force that would provide the most problems for Klal Yisrael. And they were big tzaddikim and davened, and Moshe went up to Shmayim to deliver the Torah, and from Shlomo (thru his line of Dovid) will come Mashiach. Yet Hashem didn't later go "BTW Moshe you can go to Eretz Yisrael, let's forget about that thing before - no biggy!" Nor did Hashem place a wanted ad for a new Manhig Yisrael.
Nope, Moshe on his level made an error, was told in no uncertain terms, and the consequences he lived with. Still serving and was MOSHE RABBEINU.

When we do something bad, we cause bad. No two ways about it. We have now created negativity in the world that must be rectified. However, Hashem leaves it at that and gives us a hug - any feeling of din at that point is now the Yetzer Hara. Now is the time for mercy. We keep on trucking not obliviously, but we face the reality of what we have done and then know with love from Hashem we can continue and still do great things.
Unless you want to say that you want to better than Moshe or Shlomo (please ask the admins for a quality therapist, G-dspeed), the lesson is clear. The Jewish response is recognizing our misdeed not with depression and grieving not denying or sugarcoating, but accepting, then we move on with mercy right away. Yetzias Mitzrayim is just getting started.