SpaceX’s long-awaited initial public offering, expected to fetch a $1.75 trillion valuation, has set off a frenzy among retail investors clamoring for a share of Elon Musk’s rocket, satellite and AI empire.