Cardinal Walter Kasper reportedly told a German magazine the UK was marked by "a new and aggressive atheism".
The Vatican said the cardinal had not intended "any kind of slight" and had simply pulled out due to illness.
The UK Cabinet Office said his views were personal and not representative of the Vatican or bishops in the UK.
The German-born cardinal was quoted as saying to the country's Focus magazine that "when you land at Heathrow you think at times you have landed in a Third World country".
He also criticised British Airways (BA), saying that when you wear a cross on the airline "you are discriminated against".
'Talking nonsense'In 2006 a BA employee was told to stop wearing a cross at work. She took the case to an employment tribunal claiming religious discrimination, but lost, also losing her subsequent appeal.
BA changed its uniform rules in 2007, allowing staff to display a faith or charity symbol.
Vatican sources said Cardinal Kasper - who stepped down in July as the head of the department that deals with other Christian denominations - was suffering from gout and had been advised by his doctors not to travel to the UK.
They also said his "Third World" comment referred to the UK's multicultural society.
The Cabinet Office said the cardinal had worked hard to build ecumenical relations between the Catholic and Anglican faiths.
A spokesman said: "His comments do not represent the views of the Vatican, nor those of Bishops in this country. They are the personal views of one individual."
He said the visit would further develop the relationship between the UK and the Holy See following the Queen's State visits there in 1980 and 2000.
"The visit is an opportunity to take our co-operation with the Holy See on international issues to a new level. And all involved with the visit are sure it will be a success," he said.
Not all of the cardinal's comments in the interview were critical of the UK.
He also said: "Everyone who knows England knows that there is also a great Christian tradition there."
The Pope is spending four days in Scotland and England, starting on Thursday.
The BBC's correspondent in Rome, David Willey, said the cardinal's reported comments were "a slightly clumsy thing to have done on the eve of the visit".
However, he added that he did not think it would have much effect on the Pope's trip to the UK.
Clifford Longley, from Catholic newspaper The Tablet, said the cardinal was "obviously talking nonsense".
"I don't think he believes Britain is in the grip of secular atheism, and he shouldn't have said so," said Mr Longley.
"They are saying it is ill health [that has forced the cardinal to drop out of the visit], but I wonder if that is the fact. I wonder if he has been dropped because he is an embarrassment."
British Airways said the cardinal had been "seriously misinformed" in his claims about the airline.
"It is completely untrue that we discriminate against Christians or members of any faith," it said in a statement.
SIC: BBC/UK