Supermarket sushi is notoriously mediocre at best, and sometimes outright bad. The stuff from even a moderate quality restaurant is much better, and the best restaurants are noticeably better than that.
It just is not a food that responds well to sitting around. Proper sushi rice starts drying up badly in 20 or 30 minutes or so, so they make it differently (and worse) for shelf life. Buffet sushi is bad too, for the same reason, but supermarket sushi is the worst. Also they always use inferior grade frozen fish and it's prepared crudely by someone who really doesn't know how to handle it. You will taste the different immediately.
If you like the supermarket kind, you'll love the real stuff. Though once you get accustomed you may find yourself too spoiled to enjoy the cheap kind as much.