The goal of a Network Containment Policy is to limit the impact of a compromised host on the network. This policy is designed to isolate or contain any threats or compromised devices to prevent them from spreading and affecting other parts of the network. It helps in mitigating the damage and maintaining network integrity.