Hi, Mondrian.
Yes, the Transport Museum is ideal for a car crazy 5 year old. I'm a big wean myself, and I have been daft on cars since I was about three. (Some say I'm just daft).
My granddaughter used to come to the Kelvin Hall with me when the transport museum was there. She enjoyed me pointing out all the types of cars on display that I have owned over the past 49 years.
There are plenty of audio displays and buttons to touch. Also, there is a wee shop selling toys, and there is a coffee shop for leg weary grandparents.
Hope you both enjoy your visit. Best of all, it is free.
Best wishes.
P