The Royal Photographic Society’s collection needs a strong advocate within the museum if ambitious plans for its future are to be realised by Martin Roth’s successor