Maybe not 'fragile' as in buggy, not buggy, but I found them to be 'quirky'. Sometimes stop working unless I close /re-open VScode. Stuff like that.

And other downfall. Do they still not work with DOTNET Core??

They've worked for several years now on dotnet, but the type provider author has to do some work to allow their type provider to compile and target that runtime.