> every time you convince someone that manned space doesn't make sense you convince them there's no reason to go into space at all

That's just well-sounding nonsense. People can appreciate science and exploration even if it does not involve video of humans in outer space. Video or photos of celestial objects are enough reason for the laic public and there are many physical measurements that should be done to advance our knowledge. All this can be done very well and cheaper without humans onboard.