Probably, I mean the reason most people pop a 2nd SIM in their phone is for registering on websites where they’d rather not have their main number cross-referenced and datamined. This can be anything from Amazon to personal ads sites.
But the moment you give in to the temptation to register than 2nd number with Whatsapp Meta will be able to figure out from your contacts who you are and associate it with the main number.