No, CPU thermals are unaffected by mounting pressure. You shouldn’t be too worried about how much you should tighten the CPU cooler down. Have a look at the cooler manual to see if there’s a maximum amount of threading, which is the amount you should screw down. If the manual doesn’t have that info, screw in the cooler until it feels relatively sturdy.