The two roles provided by a local NSX Manager appliance are Controller and Policy. The Controller role is responsible for managing and distributing network state to the other components in the environment, ensuring consistent networking and security. The Policy role involves managing security policies, defining rules for network traffic, and automating network configurations.