for sure there is a limit to contacts wear ............ but in this occasion, i use trays with included power switches in the enclosure loll
Still going strong after years
But for sure you're in need to remove it as a safety, only thing i can say
For other guys i know: after a thousand insertion the tray is ditched, and others say after 500 inserts ...
Maybe this ?
https://www.reddit.com/r/DataHoarder/comments/inzo2g/hdd_sata_port_durability/or this :
How durable are SATA connectors?
The connectors are SATA compliant and meet a wide range of vertical and right angle configurations for usage across server and storage equipment, HDDs and HDD carriers. Durability: 500 mating cycles ▪ Mating Force: 45N max.