no you dont have to keep the Wii on, when you want to save you press the home menu on the wiimote, this will take you back to the wii menu. your smb3 game will be saved and you are free to play other games or turn the wii off.
The next time you click to play smb3 the game will start exactly where you had exited before.
I hope this response makes more sense!