Normally Monique beats me to all French topics.

As for the Maccabees (see Wiki), they surely are all dead, aren't they? More specifically, they appeared in and gave their names to medieval events called danse macabre.

Now, s'emmerder must be a rather mechanical vulgarization of s'ennuyer without any deeper meaning, as so often found in slang. Not that I know such words, once gracing a schoolyard in France ...

The ditty seems to allude to boring sightseeing tours, specifically of Roman amphitheatres, when the guide talks and talks in the hot sun, so that the listeners (school classes) start to feel like macabre Egyptian mummies that could be dissected with a "speculum" and turned to revolting food, as the song continues. Easily found on YouTube etc.