No. Messages are stored on your Xbox profile (cloud), independent of subscription status.
Only manual deletion or account closure removes them.