After the recent loss of a member here, another member has brought up a legitimate concern-- what might happen eventually to pages "abandoned" by a deceased member.
I don't know what past SP practice has been, but unless there is a truly exceptional reason (like a truly awful page) or the family comes forth to give permission, I would not delete or transfer ownership of the page of a deceased member. In memorializing a lost member, we also memorialize that person's contributions to the site.
That is not to say that updates should not be made. If an important change is needed, you can contact the site moderators and they can make the change with as minimal a footprint as possible. But it would be better to keep the original vision and spirit of the page in accordance with the fallen member's efforts, out of respect.