How do I get my weapon to show in game?

The preview mesh of your weapon you added there is only a preview to allow you to tweak your sockets rotation/location till it looks right.

Once you’ve adjusted your sockets transform values you need to actually spawn the weapon and attach to the right socket.

Look at the node AttachToComponent and give the right socket name that matches the socket you created.