Hi Nicola, My name is***** it is just a sensor it it pretty straight forward to unthread and then install the new one and connect the wiring. Let me know
Depending on the sensor, some are pipe thread sealed and others have an o ring to seal the sensor unless it is the sensor itself leaking and not from its threads. Replace the sensor and mounting o ring if equipped. It should not blow again. If there are no operational issues and no fine metal or debris in the transmission oil or filter then there is no indication of an internal problem. You should be fine with just the sensor.