Does the nook's wi-fi only work at Barnes & Noble?

No! It will work anywhere there is a hotspot without a web-based login screen. You can use it at home with your wi-fi security, but not at Starbucks. At the store B&N will push special promotions to your nook for you.