Well,
Right off the hop, you give up Final Cut X.
You would need to seek out an approximate, thrid party iOS video editing app.
Very limited multitasking when compared to full blown computer running a full computer OS, like OS X/macOS.
No way to use standard computer peripherals and hard drives.
Limited RAM, Your 9.7 inch iPad Pro only has 2 GBs of RAM, which is NOTupgradeable.
No mice or trackpads, just touch and the Apple Pencil or other third party stylii.
If you need external storage, you are limited to “cloud” offsite data storage services or wireless, WiFi hotspot transmitter built-in external storage devices.
Since no real file system access, moving files around to use in different apps is a litle more tedious to handle.
I have been using iPads as cheaper portable laptop replacements since the first iPad, but I still own a desktop iMac that I will never give owning,
iPads, even an iPad Pro, are not a replacement for a much more powerful computer, despite Apple’s claims to the contrary.
Based on your computer usage, though, you could, most likely get by fine with your iPad Pro.
You lose the ability to do local backups of your iPad to iTunes on a computer and to other externallyexternal backup drives.
So, you would need to rely on iCloud and other “cloud” offsite data storage services and/or external wireless storage solutions.
What is the storage size of your 9.7 inch screen iPad Pro?