Pop's place in culture has changed drastically. Marcus Berkmann explains why, after 27 years, it is time to step down as The Spectator's pop critic