Query in front-page template should respect homepage settings

[jameskoster]

If you configure homepage settings to display a static page, then place a Query in the front-page template, that Query will incorrectly display posts, while the frontend correctly displays the page content:

Ideally, any Query in this template (when set to inherit) should check the homepage settings and display accordingly:

[skorasaurus]

heavily related: #20338 ; do these issues overlap close enough to close this?

[jameskoster]

That issue seems to be more generic while this one concentrates on just the interaction between homepage settings + front-page template specifically.

Updating the Query to reflect those settings in this template feels like something worth fixing in isolation since it is kind of buggy right now, so it's probably ok to keep this issue open and consider it a part of 20338.