Cathie Wood’s aggressive buying signals strong confidence in SpaceX, but investors must decide whether Elon Musk’s ambitious AI vision can ultimately justify the company’s lofty valuation.