Historians have debunked many of the popular theories surrounding the tune's creation. Still, its legacy as a patriotic anthem endures