Do I still earn points from a brand's loyalty program if I become a Drop member?

Yes, when you spend on your linked cards you will earn Drop points on top of the benefits you already receive from that brand's loyalty program.