Courtney Love has apologised for "weaponising snark" and unintentionally "bullying" Amber Heard by praising Johnny Depp over the weekend.