It’s not a big no no, it is sometimes necessary to do this, however in your installation it sounds like there were better options.
Unless your earth electrode has a stable Ra somewhere below 1ohm then you’d be better off having used the TNCS earth in my opinion.
How have you isolated the earth of the SWA at the load end of the cable? Which earthing system have you connected the armour of the SWA to?
Merely putting in an earth electrode at the shed end won’t prevent the RCD in the house from tripping. The neutral is still referenced to true earth at the substation so the RCD will see the imbalance from any earth fault or leakage. To achieve what you want you would need to install an isolating transformer and set up a TNS supply to the shed by referencing one leg of the output to earth.
This hasnt even touched on the subject of discrimination and why feeding a submain from an mcb is rarely the best practice.
I realise you only asked about testing, but all of the points raised should also come up during your NIC assessment