Why is the pilot light lit but burner won't come on in hot water tank?

The thermocouple is going bad. The thermocouple is the small tube that sits in the flame from the pilot light and goes back to the gas valve. They are easy to replace and cost $6 to $8. For health and safety the failing part should be replaced without delay by a competent gas engineer.