The Kli Yakar quoted above is a very weak source. I can pretty much guarantee that was not his source.
The source he was quoting was Bamidbar Rabbah 21:10:
ותקרבנה בנות צלפחד (במדבר כז, א), אותו הדור היו הנשים גודרות מה שהאנשים פורצים, שכן את מוצא שאמר להן אהרן (שמות לב, ב): פרקו נזמי הזהב אשר באזני נשיכם, ולא רצו הנשים ומחו בבעליהן, שנאמר (שמות לב, ג): ויתפרקו כל העם את נזמי הזהב וגו', והנשים לא נשתתפו עמהן במעשה העגל, וכן במרגלים שהוציאו דבה (במדבר יד, לו): וישבו וילינו עליו את כל העדה, ועליהם נגזרה גזרה, שאמרו (במדבר יג, לא): לא נוכל לעלות, אבל הנשים לא היו עמהם בעצה, שכתוב למעלה מן הפרשה (במדבר כו, סה): כי אמר ה' להם מות ימתו במדבר ולא נותר מהם איש כי אם כלב בן יפנה, איש ולא אשה, על מה שלא רצו לכנס לארץ, אבל הנשים קרבו לבקש נחלה בארץ, לכך נכתבה פרשה זו סמוך למיתת דור המדבר, שמשם פרצו האנשים וגדרו הנשים.
10 (Numb. 27:1) “Then came forward the daughters of Zelophehad”: In that generation the women were fencing9 that which the men were breaching. Accordingly you find that Aaron said to them (i.e., the men in Exod. 32:2), “Take off the gold rings that are in the ears of your wives”; but the women were unwilling and protested against their husbands. Thus it is stated (in vs. 3), “So all the people took off the gold rings that were in their10 ears.” Thus the women did not take part in making the [golden] calf. So also in the case of the spies who had spread slander (according to Numb. 14:36), “when they returned, they made [the whole congregation] murmur against him.” A decree was issued against them, because they had said (in Numb. 13:31), “We are unable to go up [against this people for they are stronger than us].” The women, however, were not with them in their counsel. What is written above the matter (in Numb. 26:65)? “Because the Lord had said to them, ‘They shall surely die in the wilderness,’ not a man of them remained […].” [Note that Scripture speaks of] “a man,” and not of "a woman.” Because they (i.e., the men) did not want to enter the land, but the women came forward to ask for an inheritance in the land. Therefore the parashah [about the death of that generation] was written next to this parashah, because what the men broke down the women fenced in.