When a person unsubscribes they will automatically be removed from future campaigns until they opt back in or are manually opted back in by you. You do not need to delete them from your database.
However to maintain a clean system, it may be in your best interest do do a periodic review and delete records that are no longer relevant.