Yes, except with several orders of magnitude more energy and rotating mass.
Wind turbine blades are engineered for minimum mass and inertia, are manufactured primarily from fiberglass and/or carbon fiber, are hollow, and the largest mass is in the center.
In contrast, flywheels are engineered for the highest practical inertia, are manufactured from the highest density material that works, and concentrate that mass as far out as possible.
When a wind blade fails catastrophically, it makes a mess of splinters right around the tower, as shown in [0] and [1].
In contrast, just a small automotive flywheel explosion, contained in a legally mandated scattershield, is almost as spectacular [2], [3]. Now, magnify that from a flywheel just designed to smooth the power from a 375kW (500HP) engine to the scale of a flywheel to STORE the energy of a megawatt-scale wind turbine.
So, no, the danger of a megawatt-scale energy storage flywheel is NOT like the danger of a "giant rotating wind turbine".
[0] https://www.youtube.com/watch?v=M-o-4yYb59g
[1] https://www.youtube.com/watch?v=sbCs7ZQDKoM&t=40s
[2] https://www.youtube.com/watch?v=kPat3akDiek
[3] https://www.youtube.com/watch?v=f4oxoBKRZgA