It means it will end. The recurring supporter should have a "cancel" button too, if I recall correctly.
As everyone else has said on that date your supporter rank will be removed. Then it will unlock and you can buy another one again. Cancel just means you send a message to Aikar to cancel the PayPal subscription.