One of the best school trips we had was to the local sewage farm, when I was about 11. It was really interesting.
I also remember a great one to Weymouth (the next town), where we went rock pooling. It wasn't all great - most people we wearing drainpipes, but my mother insisted I wore some old hand-me-downs, in case I got wet, so I was in old flares.. Though I wasn't the one who fell in the water.
Another good one was where we went out to the Frome river in about 3 different locations, measuring depth, width and water flow. It was just a gorgeous day at Moreton, sunny and warm, and I was always happy splashing about in water.
The ones I probably remember most we the ones I didn’t go on. In the late '70s, they discovered Dorchester''s Roman baths, which were opened to the public for a couple of days. I was at infant school, so about 6, and my class went for a visit - except me, because I didn't have my coat (hot and sunny, no chance of rain.) I had to sit in with another class. My parents did take us at the weekend, and I probably remember more of it, because I had previously been denied it.
Then when I was 8, my mother refused to give permission for me to go to the Weald & Downland museum in Sussex, on the grounds it was too far for a day trip. I finally went by myself about a decade ago (in my 30s.) It would have been a long trip, but everyone else who went survived.