No, it isn't scary.
Read the details.
The issue, deep down, stems from the fact that the FPU processor works internally at 80 bits (64 bit mantissa) and stores values at 64 bits (52 bit mantissa). This is well-known, well-documented behavior.
The error is 4e-21. It is relative based on the scale of your stuff.
Put that number in perspective. When working at the meter scale (like most games do) the error is on the same magnitude of a sub-atomic particle. Or, if you were measuring the distance between the Sun and the closest star, you could measure it in millimeters instead of light years.
Consider what that means, then consider that you are talking about trig functions interacting with those measurements.
This has been a known concern about the processor since forever. I remember reading and hearing about it in the 1980s. It affects all x87 functionality, including AMD's chips, but also the old chips by companies that are long extinct. If you had an old Tandy PC with a floating point chip, it would be affected.
Ancient and well-known problem. Basically any serious scientific simulation that needs to work at that level has already been using high-precision math libraries. Intel and AMD have both responded with a simple comment: We'll update our documentation.