This part doesn't match my experience?
"NASA is a waste" is, broadly, a conservative/Republican stance. Almost everyone I've seen outraged about the Tesla launch was noticeably left of the average Democrat. I don't think a narrative of "they hated the public version, now they hate the private version" holds up for the people I've seen.
Granted, there's a second group on the left who hated NASA before and SpaceX now. But that narrative is usually "space exploration is a waste when people are going hungry", with not much concern about public/private status.
It's definitely now also a Far Left talking point. Larry Wilmore basically went back to the old 60's, "Why is there poverty, and we're putting men on the moon?" There's a scene somewhere where he's telling Bill Nye to STFU about his Science. This brings to mind Phillip DeFranco's t-shirt about substituting feelings for facts.