Do lots of people get rectal abscess, or is it unusual?

Somewhat. Rectal abscess is not uncommon. Can be associated with conditions such as crohn's colitis and ulcerative colitis. Can be associated with a diabetic condition. Many however do not have a known cause. Antibiotics and sometimes surgery is indicated.