Sad to say I felt the same way. Maybe I've seen too many Tesla "reveal" events, or maybe some of Elon's enthusiasm has evaporated. The tone of the event was more like "This is the latest version of the Model 3" instead of "Here is OUR NEW MODEL!!"
I think Elon is not a huge fan of the CUV body style, he's more of a sports car guy. With the X it was a "bet the company" move, they HAD to sell (and at a high price). The Model Y will pretty much sell itself given it's roominess, range, surprisingly good looks (for a CUV) and low price.
I'm actually more impressed than I thought I would be primarily due to two factors:
1) Cd of "around 0.23" if I recall correctly. That's how the RWD version maintains a 300 mile range (amazing for an EV of it's relative roominess and low price). I imagine the actual Cd will be closer to 0.24 but that's still a lot better than I thought.
2) It looks pretty sharp, not the beached whale I was expecting. edit: Now that I think about this some more, I think they will probably "puff" it out a little before the design is finalized to give it the room it needs to distinguish itself from the Model 3 a little more. This will probably bring it's Cd to .24 or .25 and reduce the real world range down around 275 miles, particularly if it's all highway. Unless of course they figure out how to give the battery more than 75kWh.
The option for a third row of seats also surprised me. Not something I want or need but many will like that.
This thing is going to sell a LOT when it becomes widely available. Unfortunately, that won't be until 2021.