It's a good idea to assume that texts are stored forever. There's no technical reason to remove ~140 bytes of data when storage is cheap.

Your local data retention laws and the network's practices may vary or they may be under pressure from law enforcement to keep things longer than necessary. They will not disclose in public how long they are stored, so better assume forever.