Can SSRS used to Update or Modify data tables?
If Madeira Data shows you how to do it, then I think it's safe to say:

It's possible.

It can be made to work, as evidenced by this paragraph from them:

It’s especially good when your organization doesn’t have skilled programmers that can create a pretty-looking graphical user interface (GUI). Or when there are budget and / or time restrictions.



Deciding if this kind of setup will work for you is entirely your decision.