If you don't renew your subscription to That Pitch, all non-exclusive libraries will remove your music. That Pitch will stop collecting royalties for those work(s) for you as well. (Your membership fee covers these services 🙂.)
All exclusive libraries will keep the music (as each exclusive placement is permanent), and your royalties will be administered forever and paid out to you in full via your PRO. (Libraries cover these services 🙂.)
The subscription is billed on a monthly or annual basis from the day you sign up (depending on the plan you choose.)