Does Google Gears make any application work offline?

No. Only web sites that have been specifically designed to use Google Gears can take advantage of its offline capabilities.