It is prevalent in Thailand. Connect four hustlers are common, or so I hear. According to Jerome, they aren't so good, so any good internet player would smoke them.
I was thinking of doing the same thing in the usa, and giving the people odds like you said. You can give pretty high odds, too, if you are good, because really there are so few good connect four players. See my thread "joes vs pros in c4" for my estimate of the odds of an average player beating a GM.
I say try it, what is there to lose? If you tell people they can bet something like 2-10 dollars and that you'll give them like 10:1 to 50:1 odds, I think you'll have takers.
Just make sure you're good against all the weird moves an amateur might do. Actually, if I was gonna do it, I'd wanna know everything about c4, which is why i haven't tried gambling yet.
If you're serious about this, I can give you a list of the challenging weird moves amateurs sometimes do, and I'll give you a program that can tremendously help you study positions.