Not bloody likely. Warner had solid mechanics, accuracy and a decent arm coming out, he just came from a small school and the pro game was too big for him. (re: speed) Part of the reason he didn't stick at first was because of where he came in: Green Bay with Favre, Brunell and Detmer on the roster also. He learned speed in the AFL. Saint Louis brought him in as a backup to Trent Green and had not Green been lost for teh season, Warner may never have gotten his chance to start. He was a perfect fit for the Mike Martz offense though because he had learned to speed up his decision-making.
Tebow has completely borked mechanics, a lousy arm, terrible accuracy, can't read a defense and hasn't shown the willingness (or aptitude) to learn. He simply lacks the basic skills and attitude needed to succeed as a QB in the NFL (and CFL and AFL also). In college he played for the best teams boosters could buy and he could run at-will or throw to wide open receivers.
In the pros, a guy who was considered covered in college is wide open. He doesn't have the accuracy.