You might be surprised. On the smaller scale, look no further than Blender and Krita: Their stats indicate plenty of artists using Linux to sculpt and paint, with tablets.
But it's "big serious business" too. As evidence, see the VFX Reference Platform (https://vfxplatform.com/), a baseline for artist workstations with plenty of industry backing (vendors involved include Autodesk, Foundry, and Side-Effects; stakeholders include the Visual Effects Society and, it seems, the Academy Software Foundation). It adapts to direct studio feedback, which is certainly not an exercise in charity, and I guarantee you that they all want tablets to work as well.
Anecdotally, I've heard that big shops in-house a lot of their tools, and do so for Linux. The reasons I've heard being control & ease of integration with all the bespoke petabyte-scale server-based automation pipelines, which are most certainly Linux.
You can continue to use Wacom (only)