Show that in the Newton-Raphson method $ g'(x^*) = 0 $ and $ g''(x^*)\neq 0 $ for real roots not repeated, where $x^*$ is a fixed point.
Deriving the function $ g(x)=x-\dfrac{f(x)}{f'(x)} $, and then evaluating in $ x^* $, I have proved that $g'(x^*) = 0$. I have also found that $ g''(x^*)=\dfrac{f''(x^*)}{f'(x^*)} $.
Since the real roots are non-repetitive, $ f'(x^*) \neq 0 $. Thus, for $ g''(x^*) \neq 0 $, $ f''(x^*)$ must be different from zero. It's really $ f''(x^*) \neq 0 $. If so, could you explain why?
Your observation is correct. You can try it out directly with something like $f(x)=x+x^3$ where $$g(x)=\frac{x+3x^3-(x+x^3)}{1+3x^2}=\frac{2x^3}{1+3x^2},$$ which has a triple root at $x^*=0$, thus $g''(x^*)=0$.
The removal of the curvature term, that is, the second derivative, is one of the motivations for the third order Halley method, you apply the Newton method to the function $F(x)=\dfrac{f(x)}{\sqrt{|f'(x)|}}$. Third order convergence means exactly your contradiction case, that not only is $g'(x^*)=0$, but also $g''(x^*)$ for $g$ the Newton step for $F$ at a simple root of $f$. This means that you can construct a counter-example $F$ to the claim in question from almost any function $f$.