Ultra-low carrier density superconducting bolometers with single photon sensitivity based on magic-angle twisted bilayer graphene