How can I retrieve old text messages
How can I retrieve old text messages from cloud storage
Your use of “from cloud storage” makes the answer unclear.
If you house your messages in iCloud, they are gone once deleted. Otherwise, whatever messages were present when you last backed up your iPhone can be restored from that backup.
Restore your iPhone, iPad, or iPod touch from a backup - Apple Support