The tech team says this all depends on the number of text messages sent, time, period between iCloud being shut off etc. and depends on how Apple iCloud works.
If said messages are saved in the backup then yes. We can't guarantee this if turned off. So it is best to leave the iCloud backup on.