I suppose that must be Templo de Debod but it is not a pyramid just an Egyptian temple. It´s ok but it is not the kind of thing I would visit in Madrid.
The temple itself isn't very impressive but the views of the Palacio Real are nice, especially at sunset (if you have time, of course). On the weekend, weather permitting, there always seems to be a couple taking wedding photos.