I've used EF Core in production for years, and seen it used in production by numerous teams, and it's been at least at stable as EF6 was, while being a lot more performant.
You are correct that you don't get a VS designer, but I've personally always favoured a code-first approach anyway, so this never affected me.
> .NET Core is the Python 3 of .NET world.
I see where you are coming from, but I don't think I agree. There is still a large segment of Python 2 devs, and for many, there isn't a particularly compelling reason to move to Python 3. Dotnet Core is different, in that there are very compelling reasons to move: cross-platform (massively important in our new cloudy world), performance, and of course ongoing support. There are for sure a small hardcore of sad dotnet devs stuck on Framework because of some legacy libraries, but I reckon the majority made the move to Core a long time ago.