Visualization type is not always respected, when filters are applied

[flamber]

Describe the bug
When a question is saved with a specific visualization type, then applying filters can sometimes change the visualization type.

Reproduce 1

1. Native query > Sample Dataset - variable {{num}} as Number

select * from (
    select 'A' step, 41 users, 42 median union all
    select 'B' step, 31 users, 32 median union all
    select 'C' step, 21 users, 22 median union all
    select 'D' step, 11 users, 12 median
) x
[[where users>{{num}}]]

2. Change visualization type to Funnel and save question
   
3. Browser refresh and see that it shows as a funnel, and then input 1 into the filter widget - it now changes to Table visualization and the question becomes "dirty" with the Save-button active
   

Reproduce 2

1. Custom question > Sample Dataset > Products - Count and Sum of Price grouped by Category
2. Change visualization to Funnel and save question
   
3. Browser refresh and see that it shows as funnel, and then filter by ID > 0 - it now changes to Bar visualization.
   Looking at the URL hash, it contains "display":"funnel","displayIsLocked":true but that's not being respected.
   

Expected behavior
The auto-viz logic can be tricky, but if the column structure of results doesn't change, then the viz selection should be respected.
It should be the sweet spot between lax and aggressive, which historically has been difficult to get correct (see PR #12476)

Information about your Metabase Installation:
Tested 0.40.2

Additional context
Likely very related to #16334