You are correct, and as geoffers mentioned, if the earth lead of the new antenna is screwed to the car bodywork then there is no need to connect the earth to the wiring loom earth. I looked on my wiring diagrams and the colours it lists for the vehicle wiring was different to what you listed above, so I cannot really help with which colours are what. Pin 7 on the plug (assuming it hasn't been cut off) was the earth lead if you still want to find it. Is yours a Mk1 GS (like mine in my sig pictures)? If it is, I'll pull the carpet out later and double check the colours on my loom. Based on what I replied earlier with pin numbers, you would want the permanent feed of your aerial connected to pin 3, and the switched 12v of your aerial connected to pin 8.
If I'm honest, I would maybe try and get a genuine aerial from a breakers yard or something. Would be much easier just to plug it in. And you would get the additional features like how the aerial extends/retracts slightly, dependent on frequency range the radio is tuned in to, for optimum reception.