Two-time European winners Munster were dumped out of the Champions Cup at the pool stage for the first time in a decade as they were stunned by Castres at Thomond Park 31-29.