The Elon Musk-founded aerospace company could inject excitement into an inert IPO pipeline, but the market impact could be more muted than investors expect.