What captures peoples' imaginations isn't the vehicle. It is the journey. Or, more importantly, the destination. The vehicle is just the can they sit in to get there.

People (the vast majority, anyway) don't travel because they like to travel. They travel because they want to get somewhere. What excites their imagination is the thought of being at that place, not how they got there.

Part of the reason people aren't excited about space travel today is because there's nowhere to go. There's no orbiting low-gravity resort to vacation on, no Mars colony where Cousin Phil lives with his family to go to for Thanksgiving. And a big part of why those things don't exist is because getting people into space is a damn expensive and risky business, even today. If the only way to get to Disneyworld was to spend $20,000,000 and ride a thirty-year-old Russian relic, Disneyworld wouldn't exist either.

A cheap, safe and ugly ship would do a lot more to solve that problem than an expensive and beautiful one would.