But my question is that only with 4 GB of RAM in it, is there going to be any inadequacy in the first place ?
The first gen 12.9 iPad Pro will last a loooooong time. Think about the fact that the iPhone 7 only has 2 gb of ram, the iPhone 7 Plus with 3gb, while the 12.9 gen 1 and gen 2 models + the 10.5 model has 4 gb. There are only 3 iOS devices that run 4gb ram today.
Apple will take years to shut down support for 2gb ram devices, as the earliest devices that had it was the 6s and the Air 2. And the 6s was only released less than two years ago.