If a profile is not approved and is inactive for two months, it is deleted, yes. But they can be recovered. It's encouraged to start a new one, however, as the character might no longer be fresh in your mind after a long period of inactivity without ever writing with him. Approved profiles are never deleted.