I interpret “Cat’s in the Cradle” as being about a cat who is always demanding attention—sort of like my neighbor’s cat.
In that song the Cats are in the cradle because there are no more babies to sleep there.