I'm hoping there's a model Y killer out before the model Y ships, but if not I think I'll be really happy in a Y.
As for the acceleration. I'm married and have a kid. I drive pretty conservatively. I haven't had an accident of any kind or even a speeding ticket in 20 years. I did however find numerous occasions to floor the model S I was renting and every time it resulted in a huge grin. I'd wouldn't trade that acceleration for say a Hyundai electric that has a 0-60 in 7.6 seconds just for some extra knobs/buttons. Nor is the Hyundai cheap, starts around $38k. In a traditional ICE car the acceleration has significant down sides, cost, MPG, noise, weight, size, packaging efficiency, etc. On a Tesla the acceleration there's not nearly as much of a downside.
Being able to launch the car and be going highway speed nearly instantly is really useful whenever you have to merge in a short distance or take a right turn into high speed traffic. You can get by with an under-powered vehicle just fine in most of the country but if you're commuting in/out of a east coast city between DC and Boston it's going to come in really handy (possibly daily if your commute includes a really bad merge). Just last night some dude in a Maserati cut me off taking a right onto a two lane road where I was going ~70mph in the right lane. Had he been driving anything else I would have had to brake but he mashed the skinny pedal and I didn't have to do anything. If I had to take that turn every day I'd want something fast too. Sure it's a luxury feature but damn does it make things less stressful when you're in that situation.
I have seen a Tesla performance model described as a machine to convert money into smiles.
It does.
And seriously who on earth cares about acceleration beyond a certain point. I mean come on. Nobody is drag racing their car on the way to the supermarket to buy groceries.