Am I exposing my computer to any spyware, malware, viruses, trojans, or any other kind of malfeasance by downloading, installing and playing Frets on Fire?
No.
From what I could see the program is Open Source, which means the source code is available for people to review. Some anti-virus programs were falsely labeling it a virus, but I assume they’ve straightened that out by now.