Sounds to me like the OP has done all the sensible things already in the InDesign export, and if it just won’t go any smaller despite choosing the lowest quality options in ID, it’s going to be as Muffin Man says, vector artwork and text are keeping the file size up, and Acrobat Pro isn’t going to help. Rasterising it in Photoshop and saving as a totally raster PDF may or may not help the filesize, but will definitely reduce the quality, especially if the size is due to lovely sharp vector images and text – should be your *very last* resort.
Things to try (which may have been tried already):
Definitely postscript and distill rather than export from InDesign (usually makes a smaller PDF, even using the same job options)
Convert (or have Distiller convert) all images to RGB
Have Distiller reduce the resolution of the images as far as you can (for printing at home on a cheap inkjet, even 100dpi is fine)
Make sure the downsampling threshold is the same as the target resolution (usually job options files don’t reduce resolution unless the current resolution is more than 1.5 x the target resolution – the wording is something like ‘downsample to 150dpi for images over 225dpi’. That means with an Adobe standard job options file set to 150dpi, usually Distiller won’t start downsampling until the image resolution is over 225dpi – to get the smallest filesize, you want to downsample anything higher than 150dpi, even if it’s only 156dpi)
Don’t embed any colour profiles
Reduce the jpeg quality as far as you dare (this often makes more visible difference to the image quality than reducing the resolution)
Simplify any complex vector artwork if you can, and make sure all that’s in RGB too
If you don’t care whether the fonts stay the same from PC to PC, or the document uses fonts everyone will have, don’t embed the fonts (a font might be 1MB itself)
If you do care about the fonts, reduce the number of different ones used in the design