"Content Creation" doesn't have to be anything as elaborate as coding or painting or musical composition. Your post and mine are both "content creation," and I don't know about you, but typing more than a couple of sentences in a row on a tablet touchscreen gets old quick.
I don't personally think tablets are going away, but I think the market may shrink going forward for a number of reasons. When the iPad first appeared, they did three amazing things that laptop users immediately noticed: they turned on instantly, they were small and light, and they had high-quality screens. Tablet UI considerations aside, those were areas in which the tablet absolutely trashed existing laptop hardware in user experience. If you just wanted to read or watch a movie, and you had a laptop and a tablet within reach, the tablet would get you there faster.
Fast-forward to now, and laptops have caught up. SSDs killed the boot advantage, and new form factors made possible by the same techniques that worked in the tablets have closed the size gap. If I can get an 11" laptop that does "real computer" stuff, boots instantly, and runs quietly and comfortably in my lap... I don't really have a use-case for the tablet anymore.
In short, it was worth the inconvenience of trying to type on a touchscreen when tablets had so many other advantages-- but those advantages have all either gone away or shrunk considerably. I imagine some folks will probably reconsider their tablet. Not all, but some.