A quarter of a century ago Britain was out, loud and proud, and putting the guitar back into music. But did the welter of women-fronted Britpop bands such as Sleeper, Elastica and Catatonia create a lasting feminist legacy? Echobelly's Sonya Madan isn't so sure