No, you do not need an internet connection to play Guitar Hero on Wii.
Since the Wii Shop Channel is closed, all DLC is now permanently unavailable for purchase. Only on-disc content and previously downloaded songs work.