I think you have to temper the skepticism a bit though.

SpaceX has dramatically lowered the cost of launching things into space. They are still the leader here. They can put a kg into orbit cheaper than anyone, even heavily subsidized state operations (EU and China).

Their order book continues to be full. Every single launch vehicle they roll off the line was pre-sold years ago, including its re-use flights.

I agree that Elon is their biggest potential problem and a big risk but their launch business is sound and wildly successful. If you believe access to space will be a growing segment of the economy in the future it isn't exactly a bad investment.

I remember all the people putting Tesla down when they IPO'd. I bought $4k of stock (all I could afford at that time). Sold $100k of it a few years ago, still have the other half worth near $220k. Their numbers at IPO time were garbage and it wasn't clear they would even survive. Then they started shipping hundreds of thousands then a million cars.

YMMV, consider all sides and make your own judgement. Just be careful about trusting the anti-SpaceX case. Even if everyone is technically correct about them it can still be a huge miss not to invest! The future is not static and if they can put the raised capital to productive use the IPO could end up being a fantastic deal. And FWIW I also agree the largest immediate risk is they are over-valued. Only time will tell on that front.