Mazda sells a decent number of automatic Mazdas each year (24% of softtops, 48% of hardtops in 2018-2019 according to auto blog), so people are buying them. The reason to buy a hypothetical electric Miata? Same as for any sports car - it's faster than yours, or at least as fast I can afford.
Whether there's a market for them, I can't say, but if someone doesn't understand the existing market for an existing car, I'm extremely doubtful of their predictions about a hypothetical new car in that niche.
Of course it comes down to personal taste, but I can’t understand why you’d buy a “fun car” but strip away all the things that make it fun. There are much better alternatives at that point.
I don't expect Mazda to make a manual transmission EV Miata but it's something they could do if they really wanted to.
Really my own guess is that the manual trans will continue on the way out due to emissions law if nothing else (and lack of interest). Modern cars have little visceral interest in any case, probably better to buy a hemicuda with a stick or a Cobra kit.