It is not 'good' in the way you are understanding it, i.e. the positive benefit of partaking of the fruit. Prior to the sin, Adam acted purely in the right way and not driven by any ulterior motive. What was done was correct and proper. When they had children they came together, there was no innate desire. The act of eating from the Tree of Knowledge of 'good and bad' created a drive for pleasure and gratification that wasn't previously there.
The Ramban Bereishis 2:9 notes:
The fruit of this tree gives birth to the will and desire that those who eat it should choose a thing or its opposite, for the good or the bad. This is why it is called ‘the tree of the knowledge of good and evil,’ because da’at in our language refers to will or intention, as the Sages said ‘we only taught this in a case when his intention is to return…if it is not his intention to clear it out…’ (Pesachim 6a). This is true in biblical Hebrew as well - “what is man that you should know him?,” (Psalms 144:3) meaning that you should care about or desire him, or “I have known him by name…” (Shemot 33:12) meaning that I chose him from all other people. So too the statement of Barzilai haGiladi ‘between good and evil,’ meaning that he had lost his power of discernment and could no longer desire something or be disgusted by it, eating without tasting and hearing without taking pleasure in son. Here in the garden there was no desire for sexual intimacy between the man and his wife, rather at the proper time they joined together and gave birth. Therefore their sexual organs were exposed just as their faces and hands and they were not ashamed of them. After they ate from the tree, the choice was in their hands and they had the will to do evil or go to themselves or others. This is a divine quality from one perspective, just as it was bad for humanity as they now had lust and desire. It is possible that the verse intended this when it said “…God made men straight, but they have engaged in too much reasoning.” (Kohelet 7:29) ‘Straight’ means that one should seize on a single straight path and ‘engaged in too much reasoning’ means that one seeks various acts among which they can choose. When G-d commanded the man not to eat from the tree he did not inform him of this quality of da’at which it imparted, rather G-d simply said ‘from the fruit of the tree in the midst of the garden,’ meaning the known one in the middle – don’t eat from it. This is what the woman said to the snake, and only in a later verse does it mention the tree by name “but as for the tree of knowledge of good and bad, you must not eat of it.” (Bereshit 2:17) (Sefaria Translation)