God blessed David and promised that his Kingdom would never end. But, despite military triumphs and an appearance of success, his personal and family life was a sin-fuelled disaster