Survey USA poll taken in Fresno, CA asked respondents four questions about the speech. Overwhelming majorities expressed favorable opinions:

Q: President Obama plans to deliver a national address to school children on the importance of them taking responsibility for their own success in school. Do you think it is appropriate? Or not appropriate? For President Obama to deliver this address?
A: Appropriate 63% Not Appropriate 30%

Q: Do you think it would be appropriate? Or not appropriate? For ANY President to deliver this address?
A: Appropriate 64% Not Appropriate 30%

Q: If you had a child attending a school that was going to show the address, would you tell your child to pay attention? Would you tell you child to NOT pay attention? Or would you keep your child home?
A: To Pay Attention 78% To NOT Pay Attention 5% Would Keep Child Home 14%

Q: Who should decide whether to show President Obama's national address to school children? School districts? Or individual teachers?
A: School Districts 52% Individual Teachers 28%

SUSA asked the same questions of residents in Missouri with almost identical results.

http://www.dailykos.com/storyonly/2009/9/5/777475/-Polls-find-OVERWHELMING-support-for-Obamas-school-speech