Do "No Pet" rules on Shared Ownership sites override the Renters' Rights Act?

Yes. If the site-wide rules or superior lease prohibit pets for all residents, the landlord can reasonably refuse the request.