If you feel like going north of Albany at all, Saratoga Spa State park is really cool
There is a drive in movie theater in Hyde park NY (Just north of Poughkeepsie) I lived there last year and went a few times.
Niagara Falls is awesome, If you a passport, the Canadian side has many shops and attractions that could be cool for a 9 year old