I'd say its a good stock. The company has designed several products that everyone else is trying to catch up to and has shown that it can scale up production without running into any serious problems. So long as Musk and Shotwell are leading the company, SpaceX stock will probably be the current equivalent of early Apple stock that every boomer regrets not buying when it first came out. However, one possible downside is that SpaceX will eat up a bunch of investment money that otherwise would've gone to propping up garbage tech companies so Silicon Valley will probably enter into a very bad time financially.
The sneaky wise men of Wallstreet are probably investing in the things that SpaceX will start buying a crapton of like anything related to stainless steel processing, methane storage and piping, argon, SPMTs, and whatever else SpaceX is going to be burning through or needing. Whoever builds SPMTs is going to be very rich since there's going to be a huge demand once Starship towers start being built all over the place.
