With the news that Sabrina Carpenter will step into the triple threat’s dancing shoes for an upcoming Fred Astaire biopic, we look back at Rogers’s real world