It's convenient, simple to reduce public opinion of over a century ago to either approval, or disapproval.
I suspect, then as now, public opinion is an amalgam that results in policy influenced by that opinion or not.
In the case of manifest destiny, that was an age where news was scarce, and often word of mouth.
Labor was long and difficult, resulting in life expectancy about half what it is today. They worked themselves to death.
In that context, while individuals may have had a preference about Manifest Destiny one way or another,
many of them may simply not have had the luxury of being able to devote significant time to publicly advocate their position,
as their own survival was the priority.
The serenity prayer surfaced in the 20th Century.
Before that, even if not formalized, it was still practiced by some of our more s a v v y countrymen.
Regardless of whether they were pro or con Manifest Destiny, they understood there wasn't much they could do about it.
That is not an endorsement of it, despite the ancient Latin legal maxim:
qui tacet, consentire videtur:
He who is silent is supposed to consent. The silence of a party implies his consent.
Regarding Manifest Destiny,
possibly so,
possibly not.
the Serenity Prayer
"God grant me the serenity to accept the things I cannot change,
the courage to change the things I can,
and the wisdom to know the difference."