It means to get excited or anxious in a stupid way. For instance, getting nervous about something that isn't serious. Tripping may have it's origins in the way people act when they are on an acid trip.