Why don't you store the connectionstring to the configuration table directly in the environment variable?

It is indeed correct that when package configurations do not succeed or are not present, that the "design time" values are taken.

Regarding your last question: if you open the package it makes a connection to the configuration database under your credentials. (unless you specified SQL Server authentication). So maybe the SQL Server Agent account doesn't have read access to the configuration database?