WSR updated your Wii to system 3.4. The FW4.1 updater does require Internet access. WiiConnect24 needds to be off to avoid interference with Bannerbomb and to avoid updating to 4.2. The Internet access is a normal one through your wireless router.
Usually a frozen black screen means the IOS needed by the game is missing, but you have original game discs and allowed the game discs to update your Wii so all needed IOSes were installed in that update. Were these game discs within your region-in other words if your Wii is US, the game discs were US too?
The update would have wiped out the softmod, but your Wii still should be able to play an original game disc if it is within your own region. You are welcome to try the softmod tutorial, but something else seems to be wrong with your Wii.