consider changing is_deceased NVARCHAR(2) NOT NULL to bit, and use a 1 and 0 instead.
where do you mention deceased date?
what's the purpose of "row is current", row start...

what exactly did you backup and restore?

Always ask yourself, how many people do I need to transport how far, with how much fuel, in a 1 cylinder vehicle. 
If your expectations are realistic, as well as...

Set it up using the name of the actual instance, and afterwards redirect the publisher to the AG Listener Name.
This should guide you: https://msdn.microsoft.com/en-us/library/hh710046.aspx

You've checked everything, except network traffic and response. 
I generally see the same issue when connecting from continent to another, then there's a delay in object explorer visual response.

SSMS version on your workstation is pre-2012 is my guess.

Do you get the same response when trying to connect from a different server/workstations SSMS?

check the content of C:\Program Files\Microsoft SQL Server\130\DTS\Binn\MsDtsSrvr.ini.xml and confirm server name is correct:

<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
  <Folder xsi:type="SqlServerFolder">
  <Name>MSDB</Name>

You'll save yourself and future-you a lot of headache by developing an analysis cube and reporting from it rather. 
It should be faster, sleeker and less admin-overhead than dividing into...

SELECT DATEADD(month, DATEDIFF(month, 0, getdate()), 0) AS StartOfMonth

Is this what you require?

Your Loop will perform the required read/operation then delete the folder, you'll need to encapsulate foreach file into a foreach folder.
http://microsoft-ssis.blogspot.com/2011/01/foreach-folder-enumerator.html

Perfecting your variables will be crucial.

quite difficult since we don't know what you have developed so far, but here is a good starting point on For loops when working with files.
https://www.simple-talk.com/sql/ssis/ssis-basics-introducing-the-foreach-loop-container/

Are...

Are you using SSIS tasks or batch scripts?