Anything is possible. Google announced a streaming game service recently, but didn’t give a target date, price, or any specifics on titles available. A system capable of streaming major console/pc level games would be capable of providing other processor intensive programs.
Microsoft, from what I’ve read is much further along with a similar service. And some in the industry expect MS to begin streaming high performance apps (i.e. AutoCad, PhotoShop) to whatever screen you have in the next few years.
The technology apparently exists to do what you describe. But streaming music and video is much different than streaming major apps.
Currently iCloud is still missing important features common to other cloud storage systems (sharing folders, etc.). It is still impossible to upload multiple files through a browser making it almost useless if you aren’t working from a Mac/iPad, etc.
And IOS is still crippled because Apple has not chosen to give it parity with a Mac in several areas (i.e desktop Safari). They are a hardware company, and, AFAIK, with the exception of music, and possibly video, their services require Apple hardware. I don’t think Apple has any interest in this area.
Personally, I would put the chances of Apple ever streaming their Pro software at slim to none.