In the video, the audience can get a good insight on why CAP is required apart from practical use cases of it in banking systems, social media feeds and e-commerce sites etc.