I believe there are some emulators that could run off of Letterbomb/Smash Stack or something like that (just put the boot.dol file on the root of the SD card, start the exploit like the guide tells you and you should theoretically be golden) but I'm not savvy with those,
maybe someone else could help you with those.
Anyway, a DNS wouldn't host the game because of legal reasons. If you have Priiloader you'd be safe from bad channel installations/bricks, but BootMii would be good to have too.
My suggestion for a minimal experience
with the SMW channel instead of an emulator is to follow the
wii.guide LetterBomb guide up until you've installed the homebrew channel (although I highly recommend installing BootMii as Boot2 if possible)
Then,
install Priiloader. At this point you will have basic brick protection, against things like bad channel installations. It also had some other perks.
You can now add
WiiMod Lite, which you will use to install WADs, like SMW. With your WAD on your SD, navigate to WAD Manager on WiiMod Lite, find your WAD, and install. Once complete, you should see it on your Wii Menu and be able to play it, and you can remove the Homebrew Channel if you want. If configured correctly, Priiloader should exist in the background, unnoticeable.