I think in reality it will look stupid. It has a stupid name too. And in a line up of SUV's which follow a more level headed design language, I think it will still look stupid.
We'll see what happens I guess. I fail to see how it will be approved for any markets given its awful pedestrian safety characteristics etc. I think Musk is having a bit of a breakdown and nobody has noticed.
Design something ridiculous and everyone will notice and go crazy over it, just a very intelligent guy who knows how to market his brand with huge success even if the final product looks nothing like the concept, he nailed it proven by the pre-orders. He may get some fall out when final product looks nothing like that or it cannot be sold in certain regions but the end result is he won't care as he would still of done the numbers and be counting his billions.