This is a very interesting question. I'll take a shot at trying to provide an explanation.
"It" cannot be sure that "it" will do anything. What is "it"?
It is going to rain this week. - This is how "it" is typically used with verbs that describe a weather condition. There are weather verbs, which we can also think of as "impersonal verbs". There is no person or thing that can do these actions, yet English still requires a subject, so we use "it".
It is sure to rain this week. - Here, I would say, we are simply using "it" in the same way we use "it" in "it's going to rain this week".
Saying "it's sure to rain this week" is like saying "it is to rain this week." While I would consider "it's to rain this week" a rather unlikely sentence, it is correct.
So once again, "it is sure that it will rain this week" is illogical because "it" cannot be sure that "it" will do anything. The first "it" in "it is sure it will rain this week" is not the typical use of "it" with such weather verbs or impersonal verbs. The second part, however, is how "it" is typically used: It will rain this week.
It will rain this week. - represents the typical and correct usage of "it" with impersonal weather verbs.
It is sure to rain this week. - represents the typical and correct usage of "it" with impersonal weather verbs
It is sure that it will rain this week - The first "it" does not represent the typical use of "it" with impersonal weather verbs. What is "it" in the first clause? There's no way to justify it or identify it. However, we can justify "it" in the second clause "it will rain this week" because we know that we certainly use "it" with impersonal weather verbs. What is "it"? That's the question to ask.






