Well yes, being gay myself it does affect me more personally than others but I'd like to think that everyone would condemn homophobia when they hear it.
We all have our trigger points. Mine is racism.
I don't believe that a woman so educated and so wise in her affairs in other areas could be so foolish in this one.
It's curious, isn't it. I too wonder, and have preliminarily come to the conclusion that:
A) She has the example of her mother before her, in terms of outspokenness. Anyone who has read "A Measure of Understanding" with the revelations inside it about visions, and the general frankness about mysticism, will comprehend. I doubt Queen Sofia will ever be able to write her own expansive autobiography, though Queens Victoria and Marie certainly did. It could be, as she nears the end of her life, that she sees this book as a roundabout way to do so.
B) Queen Sofia herself is unconventional in her opinions, and has never really held back in expressing them. E.G.: She is vehemently anti-bull-fighting. One generation ago, this would disqualified her entirely in the eyes of the Spanish people. She would've been seen as "less than Spanish", which is why Queen Ena wore opaque sunglasses in her day.
Her other opinions to me are equally fascinating. She speaks about being "surprised" that the American people could've chosen a black man as President. The way she phrased it, if the transcript is correct, was rather bumptious and condescending.
To speak personally for a moment, I much rather have a human royal, with personality quirks and who doesn't always square with my views on everything, than some remote figure who I can admire or love because nothing she says or does is offensive.
Modernity is more than just about liberal values. It's about realistic expectations about people.