We've had them here in Canada for a couple of years, and there are lots of them--saw one in the parking lot in town yesterday (I'm in the country right now, but there's lots in Toronto too.) And of course Europe is teeming with them (and lots of other tiny cars that we don't have.)
I've also seem them driving on the freeway.
What I would look at it is if there are any "frequency of repair" data for them yet. The downside that I see is very little storage room. Will there really be room for your groceries? How about cargo that's a bit bigger? I would also look at reviews of its drivability (since I enjoy driving.)
We drive very little--if it wasn't for our cottage in the country (where I am now), we would not own a car. Given that, our rule of thumb for size is to choose something that is the right size most of the time, but when it's not, about half of those times it's too small, the other half it's too big. (We drive a Subaru Impreza wagon.) Obviously that's not really an issue in your case, since you have another vehicle.
I personally, in a situation like yours, would either buy a small car like a Yaris, or I'd find something fun like a Mazda Miata.
But heck, I'm sure you will have a lot of fun with this little baby!