No.  As an extreme example, suppose that $g$ is the identity (which is etale everywhere), and that $f$ is not etale at some point.  Then the fibre product is just $f$ again.

But in fact, this is essentially the general case.  If $g$ is etale (or smooth) at a point, then it is etale (resp. smooth) in a n.h. of that point, so we may replace $Z$ by the n.h. and so assume that
$g$ is etale everywhere.  Then if $f$ is not etale (or smooth) at a point $y \in Y$, the product will not be etale in a n.h. of $y \times Z.$

(Imagine that $Y$ was e.g. a nodal curve with a node at $y$, and that $Z$ is a smooth
curve.  (Here $X$ is Spec of the ground field.)  Then $Y\times Z$ is the product of a nodal
curve and a smooth curve, which just looks like a cylinder over the nodal curve; it is 
singular all along the "cylinder" over the node.)