The messages "falling off the bandwagon" (the 250 setting) are trimmed from the phone's storage.
Their attachments (unless "Saved" by you, in which case they're under your control) are trimmed too.
This happens every night around 3am, or you can do it yourself, Menu -> Compact the Database (in the app's main window, account list).