As a forever Jags fan, I would not mind if the team went 0/16 for the year in order to get the first pick for Tebow.
GO JAGS!
Why would we need to go 0-16 to get him? We can use our 4th or 5th round pick on him, he'll still be there.
But to answer the OPs question. Yes and no. Yes, more tickets probably would be sold when he first gets on the team, but he would have to start (which he won't). Then, when it's apparent he's not a good QB in the NFL, people will leave the team. They'll blame the team and it will be a disaster for the team.