If a site uses a content management system such as Drupal or Joomla, does that alleviate the need for writing HTML?
Not entirely, within your markup for the CMS you'll need to understand and use a variety of HTML and CSS to modify and create the desired output from the PHP code. It's also useful when writing blog posts to be able to modify the layout of text and images of a post.