No, it just prevents your console from using online gameplay in most games, but it will still let you browse the internet and eshop no problem.
A sure way to brick your console is messing with it's firmware.
Nintendo can't make your console commit suicide... yet.