If you're referring to "Eddie the Eagle", I can assure you he was far from second rate. He was at least fifth rate ????. He wasn't so much a national hero as he was an endearing figure who was famous for his lack of success, but yes he was thought of fondly, if somewhat a figure of fun.
If you're talking about serious competitors in motorsport, the UK has produced some all time greats like Lewis Hamilton, Carl Fogarty, Joey Dunlop, Jonathan Rea etc. and currently have 2 drivers in the top 6 of F1. We also have the most F1 championship titles of any country, ever.