The last remaining goats at a coastal site have had to be culled due to tuberculosis (TB), the National Trust has confirmed.