The main reason would be if you want the CachedRowSetDataProvider to persist across multiple page beans within the same session, i.e., to have session scope. The RowSet will have session scope in either case.
So if you will be navigating mutiple pages in a session, dropping it on the SessionBean is recommended.
Regards,
-Brad Mayer