The music video for the duo's new collaboration was directed by Dave Meyers and conceptualized by Megan Thee Stallion