How does a reduction in the money supply by the Fed make owning stocks less attractive?

The reduction in the money supply raises the interest rate. So the return on bonds increases relative to the return on stocks. The increase in the interest rate also causes spending to fall, so that revenues and profits fall, making shares of ownership in corporations less valuable.