SymPy does not simplify the expression at all.  
It returns
sin(x)**6 + 3*sin(x)**2*sin(2*x)**2/4 + cos(x)**6 - 3*cos(x)**2*cos(2*x)**2/4 + 3*cos(x)**2/4