He will never set the Thames on fire. meaning

HOME PROVERBS

exciting

He will never set the Thames on fire.

implies that:
Someone is not particularly remarkable or exceptional; said for a person who is not capable of accomplishing something extraordinary or outstanding.
It is often used humorously or sarcastically to downplay someone's abilities or ambitions.