Was this supposed to be a kid's movie?

It isn't a kid's movie as there are some heavy morals for a farce about (1) some boys wanting to become men, (2) a nice father concerned about the condemned wetlands and (3) a pretty sex worker. It's equally for teens & adults.

Frank (the kid) really just wants a caring mother, as well as a wife for his lonely, workaholic father (Ed Harris) who needs a good woman to rock his mundane world. The question is, can a call girl (Melanie Griffith) possibly be a 'good woman'? In other words, is there redemption for a soiled sex worker? If so, what is the key to that redemption? Not only is love the answer it's also the element necessary for bringing out submerged love in the one being redeemed.

Interestingly, there's also a message about objectifying a woman. The boys only see the prostitute as an object to appease their curiosity and blossoming lust, but soon discover that she's a human being with feelings and value beyond her body. Even more, the woman clearly wants OUT of the empty, repugnant lifestyle she fell into since she was 14; she craves love, wholesomeness and respect.

I'm curious if you became aware of this movie from the How Did This Get Made podcast. You posted this the same day this episode aired, so it would make sense. I actually saw this back when it came out and thought it was a little odd back then. I'm not sure its a kids movie though, this is essentially a rom-com, that happens to feature kids.